Check numeric value in Crystal Reports

Question

I need to check if the database field contains a numeric value in it. Here are a few pseudo codes:

if {myField} is numeric // do something else // do something else 

I am looking for a function that will allow me to check that '{myField} is numeric.

To help, here are some possible values ​​for {myField} and what the result should be:

 {myField} = '' returns false {myField} = 'abc123' returns false {myField} = '123abc' returns false {myField} = '123' returns true 

Answer 1

Using Crystal Syntax

 NumericText({field}) //Returns a Boolean 

Using basic syntax

 IsNumeric({field}) //Returns a Boolean