[thelist] Query successful in one db, not in another
Mark Kamian
mhkamian at hotmail.com
Fri Mar 4 14:36:09 CST 2005
Hi,
Can someone tell me why the following query is successful in one MS SQL
Server db table, but not in another?
SELECT *
FROM TABLE1
WHERE ST IN ('CA') AND (NAME IN ('LOS ANGELES') OR
VALUE1 IN (2619))
ORDER BY NAME
** Tables structures are identical
** When replacing (2619) with ('2619'), query IS successful in the other
table.
Thanks for all suggestions,
Mark
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
More information about the thelist
mailing list