Re: Simple sql select problem

Try adding NVL like so,

       AND (upper(nvl(COUNTY," ")) Not Like '%LONDON%' );

> SELECT email, surname, forename, telephone FROM tblAddressbook
> WHERE owneremail='john_at_mainframe.co.uk'
> AND (upper(COUNTY) Not Like '%LONDON%' );
>
> Cheers
> Johnny
>
>
Received on Thu Jan 17 2002 - 08:28:29 CST