[thelist] Query successful in one db, not in another

[Joshua Olson]

> -----Original Message-----
> From: Mark Kamian
> Sent: Friday, March 04, 2005 3:36 PM
> 
> 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.

Mark,

Depending on a specific database configuration, casting between strings and
numbers can happen automatically.  Check that the "Database compatibility
level" (Options tab of the database properties) is identical between the two
databases.

http://support.microsoft.com/kb/271566

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168