Special Characters are used for finding specific character string using LIKE operator in SQL SERVER.
Let's start to create database - trail
Table - Faculty
Select * from Faculty
Shows all records within table
LIKE 'V[%]' : Search string start from v character.
LIKE '[_]n' : Search string start from any character, but second character start from 'a' character.
LIKE 'ra[d]' : Search string start from specific pattern, start from 'ra' but after 'ra' must 'd' character.
NOT LIKE 'ra[d]' : Search string start from specific pattern, No start from 'ra' and after 'ra' not 'd' character in string.
There are several patterns for searching string.