Professional Web Applications Themes

Apostrophe in a string - Microsoft SQL / MS SQL Server

I'm new to SQL Server programming (I've been using Access) and wanted to know: How do I put an apostrophe in a string, if the apostrophe is the string delimiter? TIA...

  1. #1

    Default Apostrophe in a string

    I'm new to SQL Server programming (I've been using Access) and wanted to
    know: How do I put an apostrophe in a string, if the apostrophe is the
    string delimiter?

    TIA


    Ron Hinds Guest

  2. #2

    Default Re: Apostrophe in a string

    You can use two apostrophe's as an escape sequence ... Or you can also look at QUOTENAME to do the same ...

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    SCT Software Solutions
    [url]http://www32.brinkster.com/sqlvinod[/url]


    "Ron Hinds" <__NoSpam__NoSpamramac.com> wrote in message news:ecjao3nRDHA.1896TK2MSFTNGP12.phx.gbl...
    > I'm new to SQL Server programming (I've been using Access) and wanted to
    > know: How do I put an apostrophe in a string, if the apostrophe is the
    > string delimiter?
    >
    > TIA
    >
    >
    Vinodk 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. apostrophe madness
    By S. Rhodes in forum PHP Development
    Replies: 6
    Last Post: September 29th, 05:08 PM
  3. E-mail with apostrophe
    By cld007 in forum Coldfusion Database Access
    Replies: 2
    Last Post: January 13th, 04:09 PM
  4. Apostrophe replaced by ? marks
    By jelllyfish in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: October 20th, 05:22 PM
  5. Display Apostrophe problem ??
    By AdvantageLearningSystems in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: March 1st, 12:24 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