<Tr> <Td>? </Td> <Td> _ </Td> </Tr> <Tr> <Td> * </Td> <Td>% </Td> </Tr> <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> Some proprietary extensions such as Transact - SQL provide the (...) functionality, e.g., (characters) and (^ characters). </P>

Which glob character matches zero or more characters