Post reply

single quote issue

  • May 16, 2013 at 5:05 am

    #275249

    Hi all,

    I have to update a column where I am giving query which is

    Update Table Set col = '[189] IS NOT NULL and [189] <> ''' Where colid= 198

    but its giving output:- [189] IS NOT NULL and [189] <> '

    But I want output :- [189] IS NOT NULL and [189] <> ''

    actually I am not getting single quotes at last..

    Please let me know how to give update query?

    Thanks in advance...

  • May 16, 2013 at 5:18 am

    #1615698

    Hi,

    Try this.

    Add 2 more single quotes in your statement. 🙂

    select '[189] IS NOT NULL and [189] <> '''''

  • May 16, 2013 at 5:23 am

    #1615704

    Thanks for your quick reply....It works exactly as I wanted.. Thank you very much

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply