IS NOT NULL 1

[matrixindicator]

Hello,

I know you can have a statement to say give me everything WHERE for a field is no value = IS NULL.
I want a query to say give me those records where there is for a column in a field A value. I scanned a few thread and along google, no fix.

WHERE Efunction IS NOT NULL";

This does not the job, he showed every record.

 

[vacunita]

That's the correct way and it works for me. Are you sure the fields are Null and not simply empty? There's a difference.




----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[matrixindicator]

WHERE Efunctie <>''

Is there a way to check if it is null, the default value is Null

 

[vacunita]

You can combined both:

[blue]WHERE[/blue] Efunctie [blue]IS NOT NULL[/blue] [green] AND [/green][red] Efunctie <> ''[/red]

So you get neither Null nor Empty fields.


----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[r937]

also...

WHERE COALESCE(Efunctie,'') <> ''

and ...

WHERE LENGTH(Efunctie) > 0

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon