How do I search for the comma character within data stored in SQL Server?

Posted by Fred on Stack Overflow See other posts from Stack Overflow or by Fred
Published on 2010-04-30T07:05:54Z Indexed on 2010/04/30 7:27 UTC
Read the original article Hit count: 191

Filed under:

I have some data that I needs to be searched for the comma character.

example entry I need to locate in the field Citation in the Citations table: This is sometimes true, Textual Reference

In the end, I'm looking to extract Textual Reference

Selecting the column with the data:

select Citation from Citations;

© Stack Overflow or respective owner

Related posts about sql-server