For example, this query finds the system tables in a database whose names begin with “sys”: select name &hr;from sysobjects &hr;where name like "sys%" To see all the objects that are not system tables, use: not like "sys%" If you have a total of 32 objects and like finds 13 names that match the pattern, not like will find the 19 objects ... You don't actually want to escape your wildcard character. Because then you just end up comparing to the wildcard character, while what you want to do is find out if your string contains an asterisk. The way to do this is by matching on a regular expression. 'www.website.*' -match '\*'
Wildcards are special symbols that can be used to match characters in string values. TestComplete supports two standard wildcards: the asterisk (*) and the question mark (?). The asterisk wildcard corresponds to a string of any length (including an empty string).