Assume you have a table containing alphabetic, numeric, alphanumeric strings, and special characters, and you need to retrieve only the alphanumeric strings from that data.… Read More »How to fetch alphanumeric string from table
The SQL LIKE clause is used to match a value to a similar values using wildcard operators. It is used with Where Clause.
There are two type of wildcards used in conjunction with the LIKE operator.
The percent sign (%) that is used to represent zero , one, or multiple characters.
The underscore (_) that is used to represent a single number or character.