find if string/character exists in a field 1

[mplbm]

How do you find if a string/character exists in a field? I want to check for the characters ',' and '£' for all the records in a particular field. Is there an equivalent of C#'s IndexOf in SQL?


Thanks,

Mike

 

[SQLDenis]

either
select * from table
where field like '%,%'
or field like '%£'%'


both
select * from table
where field like '%,%'
and field like '%£'%'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mplbm]

Thanks Denis