Hi I know there's heaps of questions on NULL already, but is there an
easy way to TEST if a field is NULL or an empty string (i.e they did
have data in the field but deleted it and leaving the field as an empty
string as oppose to a NULL.

I'm trying to write a query and wondered if there's a way to test this
without saying IS NULL OR field = ""

Thanks,

Phil.

Try

COALESCE(Field,'')=''

Raul

On 7/12/2012 12:01 AM, Phil wrote:
> Hi I know there's heaps of questions on NULL already, but is there an
> easy way to TEST if a field is NULL or an empty string (i.e they did
> have data in the field but deleted it and leaving the field as an empty
> string as oppose to a NULL.
>
> I'm trying to write a query and wondered if there's a way to test this
> without saying IS NULL OR field = ""
>
> Thanks,
>
> Phil.

Ahhh thanks Raul! Awesome.

COALESCE(Field,'')=''