How can i get all names where field2 is not equal to 'x'

Hi,

How can i get all names where field2 is not equal to 'x'?

I did this: select name from mytable where not (field2='x')

result: only joe is fetched

this is the table:

name field2
------ -----
bob x
joe
john NULL

Thanks
Bart

Bart,

I am afraid that you have to care about NULLs, since they don't compare as
equal or unequal. So...

-- Test for the NULL explicitly
select name from mytable where not (field2='x') or field2 IS NULL

-- Turn the NULL into a zero length character string that can be compared to
a string
select name from mytable where COALESCE(field2,'') <> 'x'

RLF

"Bart" wrote in message

> Hi,
>
> How can i get all names where field2 is not equal to 'x'?
>
> I did this: select name from mytable where not (field2='x')
>
> result: only joe is fetched
>
> this is the table:
>
> name field2
> ------ -----
> bob x
> joe
> john NULL
>
> Thanks
> Bart
>