I have a requirement with sql server. Please find below the same.
In database say we have a column named "Name" in a table. The records that are available in the table are say like
Column_Name = Names
Operation Metric Lean
Cleaning and so on....
Now, through some application we are giving the input string as Project, so all the three records shown above should be retieved.
In the application i have filtered the condition like "Select name from table where name contains "Project". so i am now getting all the three records. But i am also getting the record "Cleaning" as Lean is available as part of Cleaning. Now, I should get records like cleaning.
How can I frame a query for this?
The thing is that application should search for the name that are anywhere in the column(in our case it should etch records corresponding to Lean and Cleaning..
Thanks in Advance.
February 5, 2009 3:35 AM
February 10, 2009 3:06 PM