Skip to main content

Notice

If you are using a Hotmail or Outlook email address, please change it now, as Microsoft is rejecting all email from our service outright.
Topic: Query to check if field is integer / is numeric / is hex ... ? (Read 113 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Query to check if field is integer / is numeric / is hex ... ?

Integers:
%tracknumber% PRESENT AND $max(%tracknumber%,0) LESS 1 AND [weeding out 0, 00, 000, 0000]
works, but there "must" be an elegant way?

How about to check if the content of a tag field is a decimal number (with "." as decimal separator)? Or a hex number?
High Voltage socket-nose-avatar

 
SimplePortal 1.0.0 RC1 © 2008-2021