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.