using wildcards and week() in V1

[Florian Bogeschdorfer]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net [mailto:valentina-
> bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
> Sent: Sunday, October 15, 2006 9:41 AM
> To: valentina at lists.macserve.net
> Subject: Re: using wildcards and week() in V1
> 
> On 10/15/06 10:33 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:
> 
> Hi Florian,
> 
> > Is there a way to use wildcards in a select clause, e.g.
> >
> > SELECT * FROM TABLE WHERE NAME='M**er'
> >
> > ???
> 
> Yes, use LIKE for this
> 
>    SELECT * FROM TABLE WHERE NAME LIKE 'M*er'
> 
> 
Hi Ruslan

I get very weird results, like


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

Results in first record vorname="Stephan" ??


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


This gives me NO record:

SELECT * FROM KUNDENtable WHERE vorname LIKE 'Fl*rian' no_case

Am I missing something?

Best, Florian