Special Characters are used for finding specific character string using LIKE operator in SQL SERVER. Let's start to create database - trail
-----create database
create database trail
use trail -----use database for performance on this database
----create table Faculty
create table Faculty
(
Fac_id varchar(15) not null primary key,
Fac_Name varchar(50) not null,
Subject_id varchar(50) not null
)
insert into Faculty (Fac_id,Fac_Name, Subject_id) values ('F001','Khushal','201');
insert into Faculty (Fac_id,Fac_Name, Subject_id) values ('F002','Radhika','202');
insert into Faculty (Fac_id,Fac_Name, Subject_id) values ('F003','Satish','203');
insert into Faculty (Fac_id,Fac_Name, Subject_id) values ('F004','vilas gite','205');
insert into Faculty (Fac_id,Fac_Name, Subject_id) values ('F005','rado','201');
select * from faculty
where fac_Name like 'v%'
select * from faculty
where fac_Name like '_a%'
select * from faculty
where fac_Name like 'ra[d]%'
select * from faculty
where fac_Name not like 'ra[d]%'