SQL Query that selects one word from a column many words

[bluewaves]

What is the format for selecting one word from

a Name Column?

 

Example:

 

Column=Name

Name=Sterling Silver Three Pronged Fork

 

I want to pick products that say "fork" in the name.

[o3d]

You can use charindex for ms sql.

 

You specify what your looking for as the first parameter and the string that you are searching in as the second parameter. If the first parameter exists in the second parameter, it will return the index where the string starts in the second parameter, else it will return 0 if not found in the second parameter.

 

e.g. CHARINDEX('cc', 'aa bb cc dd') will return 7 where as CHARINDEX('ee', 'aa bb cc dd') will return 0.

[anders]

Hi.

 

Do this work in mssql?

 

select * from tablename where Name like '%fork%'

 

[bluewaves]

Thank you.  I'll try that.