How to exclude null value records from query results (1 Viewer)

[gilli]

Hi,
one of the fields in my query is calling a function which returns a string value or null values. I want to exclude records that has null value in that field. I do have alias name to that function for that field. This is how I am writing the where condition in the query.

where aliasName> "";

But this is not working. What am I doing wrong?
Please guide me through this?
Thanks for any help?

 

[pbaldy]

WHERE AliasName Is Not Null

 

[gilli]

Thanks, pbaldy.
It didn't work!

 

[pbaldy]

Then the field isn't null.