SQL Wildcard Characters

There are two wildcard characters:

  • % - Represents zero or more characters e.g. bl% finds bl, black, blue, and blob
  • _ - Represents a single character e.g. h_t finds hot, hat, and hit