select * from tablename where charindex('A',columnname)<>0select * from tablename where patindex('A',columnname)<>0select * from tablename where columnname like 'A%'select * from tablename where left(columnname,1)='A'
select * from tablename where patindex('A%',columnname)<>0select * from tablename where substring(columnname,1,1)<>'A'
Select * from 表 where Patindex('%A%',字段)=1Select * from 表 where Charindex('%A%',字段)=1Select * from 表 where SubString(字段,1,1)='A'Select * from 表 where Left(字段,1)='A'
推荐用 pengdali(大力 V2.0) 说的 select * from tablename where columnname like 'A%'因为如果该列有索引的话,会使用到索引
select * from tablename where columnname like 'A%'因为如果该列有索引的话,会使用到索引