help with MATCH function

[hopkinsc]

hi all,

I am having trouble with the MATCH function.

It needs 2 parameters to work but i want the 2nd parameter to be null.

how can i achieve this?

I am currently trying.

WHERE match(Scope,)

but its throwing up an error .

[abeyphilip · Accepted solution]

Hi,

If your objective is to find nulls, then you can use -  isnull(Scope).

Or else for blanks (single blank) - match(scope,' ')

Regards,

Abey

[bbi_mba_76]

Hi,

I think you have to change the function: for null values you could use the isnull() function or len(Scope)<1

[Anonymous]

Actually what is your requirement.

Please explain in brief.

Regards

Nitin

[MayilVahanan]

Hi

Try like this

WHERE Len(Trim(Scope)) = 0;