Home Forums SQL Server 2008 T-SQL (SS2K8) Finding a quote in a string RE: Finding a quote in a string

  • December 20, 2012 at 10:19 pm

    #1570714

    dwain.c (12/20/2012)

    vinu512 (12/20/2012)

    dwain.c (12/19/2012)

    Since quote is also CHAR(25), you can also do this:

    CHARINDEX(CHAR(25), string_column) > 0

    Single Quote is char(39) Dwain......if I am not wrong. 😉

    Looked like a single quote when I SELECTed it but then sometimes my eyes aren't so good.

    Don't worry Dwain......I'm always there to help 😀

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉