--- In firebird-support@yahoogroups.com, "Dixon Epperson"
<edepperson@j...> wrote:

> > 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

Dixon, OK, you nead not only Starting 'IL' (the same as Like 'IL%')
and you can't be satisfied with Containing 'CO' regardles of 'CO'
position, but what about

Like 'IL%'
Like '__CO%'
Like '____CC'

? Manuals are very interesting books. Sometimes ;)

Best regards,
Alexander