I need to know how to get the starting position in a string using masks you use in LIKE functions. Let me clarify.
Say I have a string like "ABCDEFG123MNOPQ"
I want the starting position where the string is like ###. I don't want any Mid functions because that could take a long time to scan huge strings position by position. Does VB6 have a built in function or is there another way?
Instr("ABCDEFG123MNOPQ","123") will return my starting postion
"ABCDEFG123MNOPQ" LIKE "*###*" will return if that mask combination exists.
I need the combination of both.
Thanks in advance.