Queries with regular expressions

  • Thread starter Thread starter Emilian Szyburski
  • Start date Start date
E

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
 
WHERE said:
WHERE <column> starts with <string>

Of course <column> is of string type.
Click to expand...


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