On Mon, 07 Mar 2005 12:43:13 +0100, Lucas Franzen <luc@...> wrote:

> use an extra field to store nothing but the digits and search onb this one.
>
> I'm not sure which UDF funtion will do it, but you can also use a
> Storedproc to do so:

Hi,

I've re-formulated the stored procedure to be a trigger (one for update,
one for insert) that fill a stripped version of the field and it seems to work
fine.

Thanks very much.

regards,
Daniel

P.S.: Is there a list with all shipped UDFs with a small description?
fbudf.sql has
the function declarations, but no description (unlike ib_udf.sql).

--
eat(this); // delicious suicide