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 WHE

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) whereas