Split string and loop through against a table

fancy

13y1.8k

I have a string for e.g." Wills Smith & family, Practitioner "
I want to search keywords against a 'Company' table to determine whether the string suggests a company name or its just a persons name..

I have a table in database named as 'Company' with a single column 'Name' .
The values would be 'family','Sons','Inc.' etc . So if any of the word in the string above matches this column I should return true. Like in this case 'family' matches.

I want to break above string in store procedure as array and loop through the table to find if any of the word in the string matches in table. As soon as I get one match I want to exit . So I want to query backwards in the string as mostly company names are last word like 'inc' etc .

I am looking for good approach to solve this. I am using visual studio and sqlserver (store proc)

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Pandey13y ago
Accepted answer
split your name by space and put it into sql query by using OR operator.

string [] x= name.split by space and create your query by looping it..

ex--- "select * fromn abc where xyz like'%"+x[0].tostring()+"%'"+" or xyz like'"+x[1].tostring()+"'";

try it, if still have some issue then write your code and explain in steps what the result you need, i'll complete it and send you.

thanks
fancy13y ago
Thanks ..works fine
Vulpes13y ago
I'd suggest the following is a little tidier:

string[] split = input.Split(' ');
nam = "NAME = '" + split[0].ToString()+ "'";

for (int i = 1; i < split.Length; i++)
{
nam += " OR NAME = '" + split[i].ToString() + "'";
}
fancy13y ago
thanks this worked for me ..I am looking for the improvement in the below code if possible ...

string[] split = input.Split();
//build query with
LIKE AND OR operators based on name field.
for (int i = 0; i < split.Length; i++)
{
if (i == 0)
{ nam = "NAME = '" + split[i].ToString()+ "'"; }
else if (i !=0)
{nam += " OR NAME = '" + split[i].ToString() + "'";}
}