Like operator

[Cassio]

Is there a way I can use the Like operator in a select case stetement? I want it to have the same effect of statement below:

If m Like "200*" then
     code
Elseif m Like "test*" then
    code
end if

But there are many conditions to test and the select case would look better.

Thanks.

 

[Volte]

Select Case True
  Case m Like "200*"
    code
  Case m Like "test*"
    code
End Select

Thats really the only way to do it. Not much different than the If block really.

 

[Cassio]

Thanks VolteFace!
Do you know if there

 

[Iceplug]

I doubt theres any performance difference... both of these will check for a True condition, run specified code, and exit the entire block.
Personally, I use Select Case for selecting from a list of choices of a datatype, and otherwise, If statements.