Subject | Numeric filtering of Character fields |
---|---|
Author | Robert martin |
Post date | 2009-04-20T01:21:28Z |
Hi
We have a Character field that frequently contains numeric entries but
sometimes also contains Alpha characters as well. We want to find the
largest numeric value in the entry in the field. Casting to numeric
works fine if no Characters are in the field, otherwise it goes bang.
Is there a way (FB 2.01 ish with std functions only), to return just a
list of numeric character field values ?
Thanks
Rob
We have a Character field that frequently contains numeric entries but
sometimes also contains Alpha characters as well. We want to find the
largest numeric value in the entry in the field. Casting to numeric
works fine if no Characters are in the field, otherwise it goes bang.
Is there a way (FB 2.01 ish with std functions only), to return just a
list of numeric character field values ?
Thanks
Rob