I created a simple search in sql. inside the textchange event. everythis seem to be ok for text box. i want to have another search with the other text but this time i want to use the first search and concat it with the next condition..
here is the scenario...
once i type in the textbox and press enter all the record with the this character will return..
this is filtered in the first textbox
SELECT MRN ,FIRSTNAME ,MIDDLENAME ,LASTNAME ,GENDER ,BIRTHDATE ,MARITAL_STATUS FROM Patient_Information WHERE FIRSTNAME LIKE @FIRSTNAME+'%'
how could i put the other filter that was will be filtered by other textbox