Selecting problem on string field

[mike99]

I have a string field that contains
a) Numeric Characters
b) Alpha Characters
c) Null Values

How can I separate the Fields that contain Alpha's from the fields that contain numerics. When I use " tonumber" it hangs up on the
null's and if I set the nulls to "0" it does not like the fact that the "String is non Numeric"

Thanks

Mike

 

[dgillz]

try the isNumberic() function, which retuens either true or false. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[mike99]

Thanks

That worked for me

Mike