select  *  from  tb  where  col like '%A%'

select  *  from   tb  where  charindex(A,col)>0

------解决方案--------------------

探讨


select * from test where charindex（'A',你需要检索含A的字段)>0