Click here to Skip to main content
15,914,066 members

Comments by Member 11297177 (Top 11 by date)

Member 11297177 24-May-20 10:14am View    
yes it was working fine , thanks for solution
Member 11297177 17-May-20 17:54pm View    
sure , got it .

thanks
Member 11297177 17-May-20 10:27am View    
your correct concat function is not support supporting for 2008 R2 so i have used below query worked fine .

string str = "select * from TblPatientReg where (PID+','+PName+''+RoomNo) like '%" +txtsearch.Text + "%'";
Member 11297177 17-May-20 10:26am View    
thank you so much , which you have refereed link is worked fine. see below query worked.

string str = "select * from TblPatientReg where (PID+','+PName+''+RoomNo) like '%" +txtsearch.Text + "%'";
Member 11297177 17-May-20 8:52am View    
am using sql server 2008 but concat function not recognizing