Originally Posted by Deathader
Well, what I'm looking for are 3 different wild cards I can use while searching a textbox.
Here's an example of what I need:
? Matches any single character at the position. For example, the expression "ABCDE" Like "AB?DE" returns True because it matches any character in the third position of the string as long as the remaining characters match exactly.
* Matches zero or more characters at the position. For example, the expression "ABCDE" Like "*CDE" returns True because it matches any characters at the beginning of the string followed by "CDE" at the end of the string. Likewise, "ABCDE" Like "AB*" returns True since the two strings begin with "AB" irrespective of any following characters. The expression "ABCDE" Like "*D*" returns True because the string contains "D" preceded and followed by any number of characters.
^ Matches zero or more integers at the position. For example, the expression "12345" Like "^345" returns True because it matches any integers at the beginning of the string followed by "345" at the end of the string. Likewise, "12345" Like "12^" returns True since the two strings begin with "12" irrespective of any following integers. The expression "12345" Like "*4*" returns True because the string contains "4" preceded and followed by any number of integers.
# Matches any single digit (0 - 9) at the position. For example, the expressions "12345" Like "12#45" and "12845" Like "12#45" return True because they match any decimal digit in the third position of the string as long as the remaining characters match exactly.
Please respond asap :)
Thanks,
Alex