when i type the following query in db1 i get the error
mentioned below

select * from atsymcatransmittals
where chvTransmittalNo in
(249161, 249162, 249163, 249164)
order by guiuniqueid

they produce the following error when run in SqlTes03.yrs:

Server: Msg 245, Level 16, State 1, Line 1

Syntax error converting the varchar
value '00000020030531RIIN ' to a column of data type int.

but if i give the same query on a similar database db2 it
gives me results

if i give the search condition in single quotes in db1 it
gives me results, but still the case should be similar for
the other database db2 whih is exactly the same. any
database options which i am mising in db1

thanks

rodger



..