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

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 ... ?

2020-11-24 08:53:57

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?