where-statement for a date column

[Ruslan Zasukhin]

On 11/8/05 9:16 AM, "SoftIl" <softil at onlinehome.de> wrote:

> Hi,
>> It looks you do REGEX search, but use LIKE.
> Why do you think I use REGEX for search?
> This syntax (like '\A04.10.2004') is from the SQL-Reference Document:
> 
> How looks a right where-statement for search an value in an column from type
> date?

\A  this is REGEX anchor

For LIKE you should use

    WHERE f LIKE '%04.10.2004'


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