if not available in your version of FB

Char_Length use StrLen from Udf
SubString use SunStr from Udf ... SubStr(AlphaNum,i,i) not I for 1

----- Original Message -----
From: "Robert martin" <rob@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, April 19, 2009 10:46 PM
Subject: Re: [firebird-support] Numeric filtering of Character fields


> Thanks Hans
>
> Was trying to avoid a SP but this looks like the beest way to do it.
>
> Cheers
> Rob