What is the Sql Wild card?

What is the Sql Wild card?

SQL Wild Card is the basically use for the searching operation similarly LIKE function.SQL wildcards can substitute for one or more characters when searching for data in a database.
the following wildcards can be used:
>  % -    A substitute for zero or more characters
>  _ - A substitute for exactly one character
>  [charlist] - Any single character in charlist
> [^charlist] or [!charlist] - Any single character not in charlist


By:UMANG
Date:2014-01-09 00:00:00

SQL Wild Card is the basically use for the searching operation similarly LIKE function.SQL wildcards can substitute for one or more characters when searching for data in a database.
the following wildcards can be used:
>  % -    A substitute for zero or more characters
>  _ - A substitute for exactly one character
>  [charlist] - Any single character in charlist
> [^charlist] or [!charlist] - Any single character not in charlist


By:preet_chou
Date:2019-08-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher