UniData Concatinate in SELECT

Question

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

Answer 1

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