<P> Standard SQL uses a glob - like syntax for simple string matching in its LIKE operator . The percent sign ( % ) matches zero or more characters , and the underscore matches exactly one character . The term `` glob '' is not generally used in the SQL community , however . Many implementations of SQL have extended the LIKE operator to allow a richer pattern - matching language incorporating elements of regular expressions . </P>
<P> Standard SQL uses a glob - like syntax for simple string matching in its LIKE operator . The percent sign ( % ) matches zero or more characters , and the underscore matches exactly one character . The term `` glob '' is not generally used in the SQL community , however . Many implementations of SQL have extended the LIKE operator to allow a richer pattern - matching language incorporating elements of regular expressions . </P>
which glob character matches zero or more characters
which glob character matches zero or more characters
percent sign ( % )
percent sign ( % )