AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Sunday, March 20, 2005

Wildcards in Select statement

MVP Ken Snell showed a nice way to use wildcards in Select:
Select Case True
Case (MyVariableName Like "*10280")
' do things here if the match is valid
Case (MyVariableName Like "*99999")
' do things here if the match is valid
End Select

Cool!

0 Comments:

Post a Comment

<< Home