Utilizor
Contact Us

SQL Wildcards

Characters used in pattern matching.

SQL Wildcard Characters

A wildcard character is used to substitute one or more characters in a string.

Wildcard characters are used with the LIKE operator.

Common Wildcards

  • % : Represents zero or more characters
  • _ : Represents a single character
  • [] : Represents any single character within the brackets (SQL Server, Access)
  • ^ : Represents any character not in the brackets
  • - : Represents a range of characters