Searching for 1234567890...

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Searching for 1234567890...

Gary Clark-2
Hi List,

Can I use:

-Operator='bw', 'FIELD NAME'=($searchTerm)

Where 'searchTerm' will return all fields beginning with a numeric  
character?

Lasso 8.5 + MySQL

Many thanks in advance

Gary Clark

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/

Reply | Threaded
Open this post in threaded view
|

Re: Searching for 1234567890...

Steve Upton
At 11:13 AM +0000 11/17/08, Gary Clark wrote:
>Hi List,
>
>Can I use:
>
>-Operator='bw', 'FIELD NAME'=($searchTerm)
>
>Where 'searchTerm' will return all fields beginning with a numeric character?

I don't think so.

I think you'd be much better off doing it in SQL. Though the SQL to do it escapes me at the moment.

It's really a job for RegEx and SQL....

Regards,

Steve

--


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/