Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Hi,
If your objective is to find nulls, then you can use - isnull(Scope).
Or else for blanks (single blank) - match(scope,' ')
Regards,
Abey
Hi,
If your objective is to find nulls, then you can use - isnull(Scope).
Or else for blanks (single blank) - match(scope,' ')
Regards,
Abey
Hi,
I think you have to change the function: for null values you could use the isnull() function or len(Scope)<1
Actually what is your requirement.
Please explain in brief.
Regards
Nitin
Hi
Try like this
WHERE Len(Trim(Scope)) = 0;