Re: MI-L querying numbers to right of decimal place

2002-08-01 Thread Uffe Kousgaard
EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 10:52 PM Subject: MI-L querying numbers to right of decimal place > > I have a column with numbers and decimal places such as 13.0 and I want a > query that shows only the records that have two numbers to the right of the > decimal plac

RE: MI-L querying numbers to right of decimal place

2002-07-31 Thread Jacques Paris
2002 16:53 To: '[EMAIL PROTECTED]' Subject: MI-L querying numbers to right of decimal place I have a column with numbers and decimal places such as 13.0 and I want a query that shows only the records that have two numbers to the right of the decimal place. I can't get t

MI-L querying numbers to right of decimal place

2002-07-31 Thread Gerasimtchouk, Renee
I have a column with numbers and decimal places such as 13.0 and I want a query that shows only the records that have two numbers to the right of the decimal place. I can't get the syntax quite right. Any suggestions? Thank you, Renee --