Pattern Matching with Wildcard Characters

Wildcard characters represent one or more characters, or a range of characters, in a match_string.

like @variable + "%".

If the match string is a constant, it must always be enclosed in single or double quotes.

Use wildcard characters with the keyword like to find character and date strings that match a particular pattern. You cannot use like to search for seconds or milliseconds.

Use wildcard characters in where and having clauses to find character or date/time information that is like—or not like—the match string:

{where | having} [not]
	expression [not] like match_string
		[escape "escape_character "]

expression can be any combination of column names, constants, or functions with a character value.

select phone 
from authors 
where phone = "415%"

• Case and Accent Insensitivity
  If your SAP ASE server uses a case-insensitive sort order, case is ignored when comparing expression and match_string.
• Using Wildcard Characters
  You can use the match string with a number of wildcard characters.
• Using Multibyte Wildcard Characters
  If the multibyte character set configured on your SAP ASE server defines equivalent double-byte characters for the wildcard characters _, %, - [, ], and ^, you can substitute the equivalent character in the match string. The underscore equivalent represents either a single- or double-byte character in the match string.
• Using Wildcard Characters as Literal Characters
  To search for the occurrence of %, _, [, ], or ^ within a string, you must use an escape character. When a wildcard character is used in conjunction with an escape character, the SAP ASE server interprets the wildcard character literally, rather than using it to represent other characters.
• Using Wildcard Characters With datetime Data
  When you use like with datetime values, the SAP ASE server converts the dates to the standard datetime format, then to varchar. Since the standard storage format does not include seconds or milliseconds, you cannot search for seconds or milliseconds with like and a pattern.