Mayur  Gujrathi

Mayur Gujrathi

  • 454
  • 4.1k
  • 819.6k

SQL Server Like Query

Oct 1 2019 6:13 AM
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)