I need to search on the concatenated data in UniData using UniQuery. what are my options?
Something like below:
SELECT CUSTOMER.DETAILS WITH (FIRSTNAME:LASTNAME) = "????"
Basically below is search criteria: FIRSTNAME + LASTNAME = ?
Cheers
Try using EVAL to run a temporary expression in your query:
SELECT CUSTOMER.DETAILS WITH EVAL "FIRSTNAME : LASTNAME" = "????"
I found this blog post with other examples of EVAL as well
Try using EVAL to run a temporary expression in your query:
I found this blog post with other examples of EVAL as well