Deleting multiple rows from a table

[Dynamo3209]

Hi,
I am trying to delete multiple rows from one table and using this following query

Delete from table WHERE name IN ('a@hotmail.com',' b@hotmail.com',' j@yahoo.com',' j@gmail.com')

This query only deletes the first email address in the array that is only a@hotmail.com is deleted.
An array with int type can be deleted in this way, but can we delete a varchar type array with such query.
Thanks,
Dynamo

 

[r937]

looks okay to me, no problem with the sql syntax

are those leading blanks in the emails supposed to be there?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[ingresman]

When I get problems like this I like to use the where statement in a select to see what is being picked up. I would gues r937 is correct on this one.