Alexandre Benson Smith wrote:

> note that
>
> where
> upper(Manufacturer) = 'DATE'
>
> will return the records where Manufacturer is 'CONSOLIDATED'
>

oops.

Copy and past the wrong part.

It should be read as:

note that

where
Manufacturer containing 'DATE'

will return the records where Manufacturer is 'CONSOLIDATED'


see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br