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
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
Copyright © 2021 Jogjafile Inc.
Try using EVAL to run a temporary expression in your query:
I found this blog post with other examples of EVAL as well