That works well. -----Original Message----- From: Stephen Markson <smark...@pebc.ca> To: "rbase-l@googlegroups.com" <rbase-l@googlegroups.com> Date: Thu, 7 Dec 2017 20:46:36 +0000 Subject: RE: [RBASE-L] - query
How about: …WHERE Amount<>INT(Amount)? Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: December-07-17 3:41 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - query Group, I need to query a table looking for non-whole dollars i.e. $71.25 $102.50 etc TIA, Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.