Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> @ character in SQL

@ character in SQL

From: Scott Haynie <scott_haynie_at_msn.com>
Date: Mon, 15 Jan 2001 20:24:47 -0800
Message-ID: <uZWeVR3fAHA.274@cpmsnbbsa07> 






How do you specify the at sign (@) in a varchar field value?  I have an
email address field that will always contain @.  I get an error with
SQLSTATE 37000: '[Oracle][ODBC]Syntax error or access violation.'  If I
replace the @ with another character, it works.
Thanks for your help,


Scott
Received on Mon Jan 15 2001 - 22:24:47 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US