findTask for concatenate search: is that possible?

Discussion created by cadrin on Dec 4, 2012
Latest reply on Dec 5, 2012 by dbecker88
Hi all,

I would like to make a search for an address (i.e.: "45 wolfe") and retrieve some data where there is a match. But the trick is that the "45" is from the column [CIVIC_NUM] and the "wolfe" is from the column [ROAD_NAME].

Here is my table structure: [ID, CIVIC_NUM, ROAD_NAME, CITY, STATE].

Is there a way to do this?

For now, I'm only able to search separately for each element (such as "45" or "wolfe").

Thank you.