Alex & Access

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

About Me Search
My Photo
Name:Alex Dybenko

Location:Moscow, Russia
Google
 
Web AccessBlog.net

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

Links to this post:

Create a Link

<< Home