Re: @ character in SQL

From: <jocave_at_my-deja.com>
Date: Tue, 16 Jan 2001 16:29:48 GMT
Message-ID: <941sth$s2m$1@nnrp1.deja.com>

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.

Make sure that you have the latest ODBC patch from OTN. This sounds like a bug that has been fixed.

Justin Cave

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 16 2001 - 10:29:48 CST