If there is a decimal "point" in all the lines then try Select * from ur_tab where len(str$(ur_tab.ut_col)) - instr(1,str$(ur_tab.ur.col,".")=2 into sel
If there are cases without decimal point, then add an extra condition: Select * from ur_tab where instr(1,str$(ur_tab.ur_col,".")>0 and len(str$(ur_tab.ut_col)) - instr(1,str$(ur_tab.ur_col,".")=2 into sel Jacques Paris e-mail [EMAIL PROTECTED] MapBasic-MapInfo support http://www.paris-pc-gis.com -----Original Message----- From: Gerasimtchouk, Renee [mailto:[EMAIL PROTECTED]] Sent: July 31, 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 the syntax quite right. Any suggestions? Thank you, Renee --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2296 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2297
