> If you need to know if the 3rd Character is a G you can use:
> IF ( MYFIELD LIKE '__G%' ) THEN
> BEGIN
> END

Good one Lucas!

Why didn't we think of this - I was about to send an email about
a couple of UDFs that could be used for all this!



With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com