Q&A BY TAG 'coalesce'

You must sign in to ask a question. If you do not have an account, you can register here

Finished with error: Function 'ifnull' with arity 2 not found
answered 12-03-2018 09:01:29 -0400

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(ifn...

Answers: 1

coalesce CASE

Using the COALESCE function with Dates
answered 14-07-2017 09:28:34 -0400

Will appreciate if someone can help me with the following using the COALESCE function Query purpose: To return a particular Date value. If no Date value is returned, use January 1 0001 as the default Select coalesce(bv_test.find_my_dt, to_date('MMMM ...

Answers: 1