Post reply

Set statement with single quote in statement

  • August 1, 2008 at 10:10 am

    #382110

    I'm doing an update and the set field in the update is as follows: set description = '16"X14' PR F/G bead’. The problem I’m having is the single quote after the 14 is for feet, not to end the statement. How can I get around this? Thanks for your help.

    gsmith

  • August 1, 2008 at 10:49 am

    #852036

    You have to use dynamic sqk for this

    set description = '16"X14''' + 'PR F/G bead'

    -VG

  • August 1, 2008 at 11:01 am

    #852046

    Actually just putting two single quotes will give you the single quote without closing the string. You don't have to go to string addition.

    Here is an example.

    DECLARE @DESC VARCHAR(25)

    SET @DESC = '16"X14'' PR F/G BEAD'

    PRINT @DESC

    -Ben

  • August 1, 2008 at 11:44 am

    #852067

    Thanks everyone, that worked out great!

Viewing 4 posts - 1 through 4 (of 4 total)

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