regular expressions 1

[ktighe]

Does Access provide any regular expression support? I know that the '*' wildcard is supported, but are there any other wildcards that I can use? I'm trying to pull out fields where the date is in the format xx.xx.xx in my query, but I cannot figure out how. I need a wildcard that specifies any single character. I tried '&', but it didn't work.

Here's what I'm trying to do:

in the Criteria field of my query: Like "*.&&.*"

Any help would be greatly appreciated.

Kevin

 

[Aivars]

Use a questien mark e.g.
Like "e?t*"
>Enter ....
>Externel ....

Aivars

 

[ktighe]

Thanks for the quick response! Worked like a charm.
Kevin

 

[tlbroadbent]

You can use ?.

Like "*.??.*" Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin