Table 5: Query Results when Accepting NULL and Empty String as Valid Integers

 

Keycol

string

is_numeric

is_int

1

12345

1

1

2

abc

0

0

3

NULL

0

1

4

1E3

1

0

5

12.4

1

0

6

+123

1

1

7

-2345

1

1

8

 

0

1

9

$123

1

0

10

2147483647

1

1

11

2147483648

1

0

12

9223372036854775808

1

0