universeunidatauniquery

UniData Concatinate in SELECT


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


Solution

  • 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