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.

Please advise

Thanks and regards
Bhavbhuti