[V4MD] regex & escape

[Martin Kloss]

At 17:52 17.12.2003, you wrote:
>Let's forget about escaping.
>Please show me small example. Records you have

Do you still have my DemoDB?
You can try this with the demo db I sent you:

SELECT * FROM Data WHERE title LIKE '(?i)petrova'
-- returns 1 record

SELECT * FROM Data WHERE title LIKE '(?i)petr?va'
-- returns 0 records

SELECT * FROM Data WHERE title LIKE '(?i)petr*va'
-- returns 0 records

Which is funny, because in other cases it works:

SELECT * FROM Data WHERE title LIKE '(?i)p?trova'
-- returns 1 record

SELECT * FROM Data WHERE title LIKE '(?i)p*trova'
-- returns 1 record

This doesn't make any sense to me...

Martin.