sql server - SQL like query not returning correct result -


I am using a SQL server I have a table 

  Company ABC XYZ ABC, XYZ   
 When I run a similar query  where the company is like '% ABC%'  only  ABC  and < Code> ABC, XYZ   
  
 How can both be recorded?   
 
 
 First of all, you should not have a separate comma separated list in a column. By doing this, you will participate in the issues trying to ask for data.  
 Secondly, your code should work:  
  Select  company where '% ABC%' like   
 A

Comments

Post a Comment