This function compares a string to a mask. The string can be a database field containing a string or a text string. Mask may contain one or multiple wildcards such as ? for a single character or * for any number of characters.
LooksLike( string, mask )
x | database field containing a string or a text string |
---|---|
mask | string containing wildcards like ? or * |
True, if x and mask are equals, taking account of any wildcards in mask.
lookslike ("Berlin", "B?rlin") // Returns True. lookslike ("Berlin", "B???in") // Returns True. lookslike ("Berlin", "B*in") // Returns True. lookslike ("Berlin", "B?lin") // Returns False.