Professional Web Applications Themes

Apostrophe sign in TSQL string - Microsoft SQL / MS SQL Server

I buld dynamic SQL that selects something. "Where" clause should contain the following string: WHERE vstrName='someString' How can I dynamically insert into string an apostrophe sign ? I use the following code: DECLARE SCRIPT_2_EXECUTE varchar(2000) SET SCRIPT_2_EXECUTE = '....'+ 'WHERE vstrName=...... '+ EXEC(SCRIPT_2_EXECUTE) I c language i used to prefix special character with backslash \ sign. Is there a couterpart of it in TSQL ? If not, how to put apostrophe into varchar variable ? Thanks for any suggestions Michal Januszczyk...

  1. #1

    Default Apostrophe sign in TSQL string

    I buld dynamic SQL that selects something.
    "Where" clause should contain the following string:

    WHERE vstrName='someString'


    How can I dynamically insert into string an apostrophe
    sign ?

    I use the following code:
    DECLARE SCRIPT_2_EXECUTE varchar(2000)
    SET SCRIPT_2_EXECUTE = '....'+
    'WHERE vstrName=...... '+

    EXEC(SCRIPT_2_EXECUTE)


    I c language i used to prefix special character with
    backslash \ sign. Is there a couterpart of it in TSQL ?
    If not, how to put apostrophe into varchar variable ?

    Thanks for any suggestions
    Michal Januszczyk




    Michal Guest

  2. #2

    Default Re: Apostrophe sign in TSQL string

    You need to use the REPLACE function in SQL Server to replace all occurences
    of ' (single quote) with '' (two single quotes).
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Michal Januszczyk" <com> wrote in message
    news:086b01c355bd$c1956840$gbl... 


    SriSamp Guest

  3. #3

    Default Re: Apostrophe sign in TSQL string

    Look for QUOTENAME in Books Online
     


    Alex Guest

  4. #4

    Default Re: Apostrophe sign in TSQL string

    Use 2 apostrophes:

    SELECT * FROM TABLE
    WHERE field = 'test'

    Dynamically written becomes:
    sql = 'SELECT * FROM TABLE ' +
    'WHERE field = ''test'''
    EXEC(sql)


    -- Hans De Schrijver


    "Alex Cieszinski" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Hans Guest

Similar Threads

  1. PHP and the apostrophe (')
    By Otto Haldi in forum PHP Development
    Replies: 3
    Last Post: February 28th, 12:45 PM
  2. Sign In/Sign Out like macromedia page
    By ajohn30@adelphia.net in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: April 25th, 09:33 AM
  3. minus sign proportion to + sign in bold
    By Weintraub in forum Macromedia Freehand
    Replies: 7
    Last Post: August 2nd, 03:39 PM
  4. TSQL Query
    By Rayan in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 17th, 12:48 PM
  5. Apostrophe in a string
    By Ron Hinds in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 10th, 02:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139