2
Answers

SQL Server Like Query

Photo of Mayur  Gujrathi

Mayur Gujrathi

5y
761
1
Dear All
 
My below query is working fine 
 
SELECT
*
FROM tablename(nolock)
WHERE column LIKE 'A%B%C%'
 
But i want same even if  search sequence is  getting change like 
 
SELECT
*
FROM tablename(nolock)
WHERE column LIKE 'A%C%B%'
 
In first query A is before B and in second vice versa 
 
 
 

Answers (2)