Using the Code

1. Create a table with some dummy records to  show the demonstration:
   Hide   

   Copy Code

   create table tbl_test(id int identity(1,1),column1 nvarchar(50),coulmn2 nvarchar(50),coulmn3 nvarchar(50))-- Create a table insert into tbl_Test (column1,coulmn2,coulmn3) values('Griff','Serjey','Maciej'),('King','Fisher','Ajay'),('Paul','Griff','Serjey'),('King','Fisher','Griff')--Inserting some Dummy Records

2. Now, I'm going to search the value where the data is 'Griff'. In the above table, there are 3 rows that contain 'Griff'.
   Hide   

   Copy Code

   select *from tbl_test where 'Griff' IN (column1,coulmn2,coulmn3)

3. By executing the above query, we will get the resultset like below:
   Hide   

   Copy Code

   id   column1    coulmn2    coulmn31    Griff      Serjey    Maciej3    Paul       Griff     Serjey4    King       Richard   Griff

The query will check all the mentioned columns where the input data is available by using the simple 'IN' clause.