Phil,

> During the import of a large number of records, I need to check the last
> character of a string contained in a varchar field for a certain value.
>
> This can be done with a combination of the STRLEN and SUBSTR UDFs but has
> quite an impact on the speed and performance of the import process.
>
> Is there an 'SQL' way of doing this?

perhaps COLUMN LIKE '%X' where X is the character you are looking for.
Ciao
--
____
_/\/ando