UniData Concatinate in SELECT

306 views Asked by At

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

1

There are 1 answers

1
webthaumaturge On BEST ANSWER

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