Dear torque users,
Please help me with writing following select criteria for torque.
I have person table with fields first_name and last_name.
Sql equivalent of the query looks like this:
select * from person where
upper( last_name || ' ' || first_name ) like upper( ? )
Given parameter can be something like this:
"%Smith J%" => returns all John Smiths,
"%john%" => returns all Johns, etc.
How can it be done with Torque? Can it be done with Torque?
with best wishes,
Taavi
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
