Let me show you how to search a record from multiple columns in a table by using Simple '
IN' Clause in SQL Server.
Using the Code
- Create a table with some dummy records to show the demonstration:
create table tbl_test
(id int identity(1,1),
insert into tbl_Test (column1,coulmn2,coulmn3) values
- Now, I'm going to search the value where the data is '
Griff'. In the above table, there are 3 rows that contain '
select *from tbl_test where 'Griff' IN (column1,coulmn2,coulmn3)
- By executing the above query, we will get the resultset like below:
id column1 coulmn2 coulmn3
1 Griff Serjey Maciej
3 Paul Griff Serjey
4 King Richard Griff
The query will check all the mentioned columns where the input data is available by using the simple '
Yeah, it's very simple, but I hope it's a very helpful tip.
- Created and published on May 22nd, 2015