Hi,

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?

Cheers

Phil
--
Linux 2.4.4-4GB
4:21pm up 9 days, 5:47, 1 user, load average: 2.04, 0.65, 0.26