Help with quotes!

[tabbytab]

Hi Guys

I have a sql query that includes an email adress in the Where clause

ie strEmail = xx.xx@xx.com

I cannot get this to work.
I've tried single & double quotes around the email address.

Where strEmail = "xx.xx@xx.com"
Where strEmail = 'xx.xx@xx.com'
Any clues?

Thanks in advance
TabbyTab

 

[gmmastros]

strEmail is probably a varchar field, so you would want to use single quotes. Is it possible that there are some unseen characters involved. For example, if the database has xx@xx.com[!]TabCharacter[/!] and you are searching for it without the tab character, then you won't get your match.

Hope this helps.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

works for me

create table EmailTable (email varchar(50))
insert into EmailTable
select 'xx.xx@xx.com' union all
select 'aa.xx@xx.com' union all
select 'bb.xx@xx.com'

select * from EmailTable
Where Email = 'xx.xx@xx.com'


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/