Like Operator

Syntax

                str1 Like str2

Group

Operator

Description

Return the True if str1 matches pattern str2. The pattern in str2 is one or more of the special character sequences shown in the following table.

Chars Description

? Match any single character.

* Match zero or more characters.

# Match a single digit (0-9).

[charlist] Match any char in the list.

[!charlist] Match any char not in the list.

Sub Main
    Debug.Print "abcdfgcdefg" Like "" ' False
    Debug.Print "abcdfgcdefg" Like "a*g" ' True
    Debug.Print "abcdfgcdefg" Like "a*cde*g" ' True
    Debug.Print "abcdfgcdefg" Like "a*cd*cd*g" ' True
    Debug.Print "abcdfgcdefg" Like "a*cd*cd*g" ' True
    Debug.Print "00aa" Like "####" ' False
    Debug.Print "00aa" Like "????" ' True
    Debug.Print "00aa" Like "##??" ' True
    Debug.Print "00aa" Like "*##*" ' True
    Debug.Print "hk" Like "hk*" ' True
End Sub

Copyright Help/Systems LLC and its group of companies.
All trademarks and registered trademarks are the property of their respective owners.

Chars	Description
?	Match any single character.
*	Match zero or more characters.
#	Match a single digit (0-9).
[charlist]	Match any char in the list.
[!charlist]	Match any char not in the list.