Finding a string inside a string using T-SQL 1

[hellferret]

Is there an InStr() equivelant in SQL?

I want to return all records where a field contains a certain string.

Is this possible?

 

[Cagliostro]

try to use charindex(row,'one sequence') John Fill

 

[hellferret]

Thanks! It works a treat.

 

[Cagliostro]

was my post helpful ? John Fill

 

[hellferret]

There you go. A little purple star for you.

 

[Cagliostro]

Thanks, John Fill