> SELECT s.TAXNAME, t.TAXVAL FROM SALESREG s, TAXTBL t
> WHERE s.TAXNAME LIKE 'CO%'
>

Raul,

thats not what I'm looking for. I did find the SUBSTR UDF, and have
been experiementing with it, but don't know how to setup and use a
UDF

Example
SELECT * FROM SALESDETAIL s WHERE SUBSTR(s.SD_TAXCODE, 3,2)='CO'

sd_taxcode might be 'IL '
or it could be 'ILCO '
or it could be 'ILCOCC'

is SubStr the right idea here and how do you implement a UDF. I
mean is it all ready there and you just need to link to it, or is it
a piece of code you have to write. Can I do it in Delphi?

Dixon