Search:

This "@" is to take the value from the user:

SELECT * FROM Patient WHERE Patient_Status LIKE @disease
it's working fine but to be a match...the user's inpout must be exactly=the text in the...

the sql statement is not working :S

yes, but the problem is...instead of "The Text" , I want "The Text" is what the user want to search for (Take the string from the user and apply it in the sql statement)...and it's a c# application...

Hello everyone, I have a DB here that has an attribute "Status" it's a text ... I wanna make a search field in the form application that when the user enters a certain key word the application...