precision differences between Windows Linux?

2004-07-23 Thread Kevin Ward
I have come across a very strange occurrence while working on a client's system. I get different behavior between the two servers (one Windows, one Linux) when it comes to a column defined as double(5,4). The Windows system truncates new values (existing data in the table is not truncated)

RE: Another newbie question - using OR in WHERE clauses

2004-07-23 Thread Kevin Ward
Paul, You can do the following: SELECT * FROM tablename WHERE columname IN ('Bob','Mike','Betty'); Kevin -Original Message- From: Paul Fine [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:01 PM To: [EMAIL PROTECTED] Subject: Another newbie question - using OR in WHERE