2
Answers

SQL Server Like Query

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)