Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kenneth Fisher Single Quotation Marks in SQL RE: Single Quotation Marks in SQL

  • January 3, 2013 at 7:07 am

    #1573305

    RichB (1/3/2013)

    How about using Quotename...?

    SELECT QUOTENAME('o''neil', '''')

    Yes, QUOTENAME is my preferred method of dealing with dynamic SQL. Especially since it can also handle brackets.