[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