My requirement is,I want to search records,in my application,
This are the Text box available on the screen where user will enter values in any one text box and based
on this value records should be display.
So I written query for this as,I enters some code in Code textbox,so this should retreive only the
records for code like R0000299,but it displays all the records,
Select A.* From CRM_Customer_Master A Join CRM_Loan_Master B
On A.Lnno = B.Lnno
Where A.Lnno Like '% %' Or SNo Like '% %' Or Code Like '%R0000299%' Or Name Like '% %')
Kindly provide solution for this,as I need this urgently.
Thanks in Advance!