Queries with regular expressions

[Emilian Szyburski]

I want to do a query with a conditions of a type

WHERE <column> contains <string>

WHERE <column> starts with <string>

Of course <column> is of string type.

I wanted to do it using reqular expressions (like you can do it in MySQL)
but it doesn't workk.

So, how can it be done in MS Access ?

Emilian Szyburski

 

[Chuck]

WHERE <column> starts with <string>

Of course <column> is of string type.

WHERE <column> LIKE "string*" will return all records that start with
"string"
WHERE <column> LIKE "*string*" will return all records that contain
"string"