> Hi all
>
> In one of my queries in the WHERE I had to put in the following to
> filter correctly
>
> AND tSI.cDocType NOT IN ('PROFORMA', 'PROFORMASECSALE')
>
> I was hoping to write something like
>
> AND tSI.cDocType <> 'PROFORMA%'
>
> but this would include both the types of records, not sure what I need
> to do to do a partial match.

NOT LIKE
--
Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -
jetzt kostenlos herunterladen! http://portal.gmx.net/de/go/chbrowser