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

[Mark Kamian]

Thanks for the responses on this.

The issue IS attributable to the differences in how SQL 7 & 2000 treat 
column data that contains both numeric and character values, as described in 
the article below.

-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
>
>
> >
> > 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,
>
>--
>
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/