on 6/29/02 15:32, Carlo Sacchetti at carlo.sacchetti At tin DOT it wrote:
> Hi Ruslan,
> thanks for your help. Finally I resolve the problem with SQL function. Now I
> have another problem. I use the function "locate ('bar','combar'). It run very
> well, but it'is case sensitive. There's a way to make a no caseSensitive
> search with this function, without use another method like UPPER(). More word
> have only one case letter (the first). I try to use no_case but not run.
Of course, no_case work only for fields.
You need make you method as locate ( lower('bar'),lower('combar') )
Then you method will become case insensitive.
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on At lists DOT macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
