Professional Web Applications Themes

single quotes in select statement - Microsoft SQL / MS SQL Server

In this case, the employee name has a single quotes, so the following select statement actually inquires 'WILLIAMS, O'. How can I bypass this? Select * from tblEmployee where name = 'WILLIAMS, O'WONDER' Thanks....

  1. #1

    Default single quotes in select statement

    In this case, the employee name has a single quotes, so the following select
    statement actually inquires 'WILLIAMS, O'. How can I bypass this?

    Select * from tblEmployee
    where name = 'WILLIAMS, O'WONDER'

    Thanks.


    Michelle Guest

  2. #2

    Default Re: single quotes in select statement

    Double the internal single quote (make it two single quotes) as:
    'WILLIAMS, O''WONDER'

    Russell Fields
    "Michelle" <Michelle> wrote in message
    news:uFVpcIYRDHA.2232TK2MSFTNGP11.phx.gbl...
    > In this case, the employee name has a single quotes, so the following
    select
    > statement actually inquires 'WILLIAMS, O'. How can I bypass this?
    >
    > Select * from tblEmployee
    > where name = 'WILLIAMS, O'WONDER'
    >
    > Thanks.
    >
    >

    Russell Fields Guest

Similar Threads

  1. CFMX7 duplicating single quotes in sql statement
    By Loony2nz in forum Coldfusion Server Administration
    Replies: 1
    Last Post: September 18th, 08:02 AM
  2. single quotes and SQL
    By nedflanders in forum Macromedia ColdFusion
    Replies: 0
    Last Post: March 31st, 08:56 PM
  3. Single Quotes vs Double Quotes
    By Dave Dash in forum PHP Development
    Replies: 0
    Last Post: September 11th, 02:47 PM
  4. [PHP] Single Quotes vs Double Quotes
    By Tom Rogers in forum PHP Development
    Replies: 0
    Last Post: September 9th, 04:20 AM
  5. Recommend pse: Quotes, Single Quotes, etc. basics
    By charlie in forum ASP Components
    Replies: 1
    Last Post: July 1st, 12:28 AM

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