query special character

From: Tuan Tran <tuan.tran_at_verizon.net>
Date: 21 Jul 2001 00:43:47 -0700
Message-ID: <4a17640d.0107202343.5931a3e@posting.google.com>

Please help.
I having problem with @ special character in my database.

when I do a select statement in sqlplus select * from subscribers
where email = 'johndoe_at_yahoo.com';
I got no rows selected from the server.

but if I do
select * from subscribers
where email like 'johndoe%';
then the server returned:
EMAIL

---

johndoe_at_yahoo.com

is there a way where I can do the first query (select * from subscribers where email = 'johndoe_at_yahoo.com' ) and get the record back?

Thanks in advance. Received on Sat Jul 21 2001 - 02:43:47 CDT