Here's a table:

Create table foo (
bar varchar(25)
.. Other fields ...
);

bar has some entries that are legal numbers and some that are not. I'd like
to find the
largest value for bar considering only those rows where bar is a legal
number. In some
databases, I could say this:

Select max(bar) from foo where isnumeric(bar).

It appears that Firebird has no isnumeric built-in. Is there something else
I could use?
A UDF somewhere, maybe?

Michael D. Spence
Mockingbird Data Systems, Inc.



[Non-text portions of this message have been removed]