IsDouble

Table of Contents



Returns true (1) if the given value can be converted to a decimal number.

Boolean IsDouble(String value)

Boolean results

Boolean functions return 1 for true and 0 for false. In a WHERE clause compare the result to 1 (or true), for example: WHERE IsLike(Text, 'Cat%') = 1


round-pushpin Tests two values.
SELECT IsDouble('1.5') as Yes, IsDouble('abc') as No FROM Single