Re: @ character in SQL

From: <steveee_ca_at_my-deja.com>
Date: Tue, 16 Jan 2001 17:14:29 GMT
Message-ID: <941vhc$up3$1@nnrp1.deja.com>

Hi Scott,

I don't know what version you're using..on 8.1.6 it's no problem..I'll include an example here:

SQL> CREATE TABLE ATSIGN(COL VARCHAR2(3)); Table created.

SQL> INSERT INTO ATSIGN
2 VALUES('@'); 1 row created.

SQL> select * from atsign;

COL

---
@

Steve


In article <uZWeVR3fAHA.274_at_cpmsnbbsa07>,
  "Scott Haynie" <scott_haynie_at_msn.com> wrote:


> 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

>

>



Sent via Deja.com
http://www.deja.com/

Received on Tue Jan 16 2001 - 11:14:29 CST