This is my query which I am trying to use in VQL Shell
"SELECT srno_0, employeeid, firstname, lastname, country,
Coalesce (
CASE
WHEN Country= "USA" THEN (concat(ifnull(substr(SSN,1,3), ''), '-XX-XXXX')) end,
CASE
WHEN Country!= "USA" THEN (concat(ifnull(substr(SSN,1,11), ''), ''))else null end )as SSN
from admin.employeeinformation_dv;"
The problem is that when I run this query on VQL Shell I am getting below error.
"**Finished with error: Function 'ifnull' with arity 2 not found**"
Can some one please help me to resolve this issue.Thanks in advance for your help.