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

That's really the only way to do it. Not much different than the If block really.

[Cassio]

Thanks VolteFace!

Do you know if there´s a performance diference in using the select-case or the if-then-elseif?

[Iceplug]

I doubt there's 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. :)