using wildcards and week() in V1

[Ruslan Zasukhin]

On 10/15/06 11:35 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian, 
 
> I get very weird results, like
> 
> 
> "SELECT * FROM KUNDENtable WHERE vorname LIKE '*lo' no_case"
 
> Results in first record vorname="Stephan" ??

Try 

 "SELECT * FROM KUNDENtable WHERE vorname LIKE '.*lo' no_case"


> While here I get correct results (eg "Florian", "Ilona"):
> 
> "SELECT * FROM KUNDENtable WHERE vorname LIKE 'lo' no_case ORDER BY KD_ID"

> And this gets me ALL records:
> 
> SELECT * FROM KUNDENtable WHERE vorname LIKE 'Fl***an' no_case

Wait. 
    
    *  is MANY ANY chars.

It seems you use it as ONE char ?
Then you need do 

        LIKE 'Fl...an'

Please find in V4MD v1 archive document "RegEx syntax"


> This gives me NO record:
> 
> SELECT * FROM KUNDENtable WHERE vorname LIKE 'Fl*rian' no_case
> 
> Am I missing something?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]