using wildcards and week() in V1

[Ruslan Zasukhin]

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'


> And why does this not work (error 616):
> 
> select geburtsdatum from kundentable where week(geburtsdatum,1)=7

More hard question...

Must check what is 616

-- 
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]