Select * From [table] where [column] like '%st%' and [column] like '%saint%'
-- stjohns, saintanns, st.Peterburg -- and if u pass "st." then 1 reocrds will display -> st.Peterburg -- and if u pass "st" then 2 reocrds will display -> stjohns, st.Peterburg -- and if u pass "s" then 3 reocrds will display -> stjohns, saintanns, st.Peterburg Declare @val varchar(100) = 's' SELECT * FROM YourTableName WHERE YourColumnName Like '%+ @Val +%'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)