查看数据库中是否存在某字段以xxx开头的记录，sql语句怎么写

[gsxrb521]

比如有字段 masseq，值可能为 100001,100002,200001,200002....
查看数据库中是否存在masseq字段以xxx开头的记录，比如200，
sql语句怎么写 。

[lounddong]

select * from table where substring(masseq,1,3) = '200'

[bancxc]

select * from tb where masseq like '200%'

[华夏小卒]

select * from tb where masseq like '200%'

[--小F--]

select * from tb where masseq like '200%'

[jwdream2008]

select * from table where left(maseq,len(200))='200'

[--小F--]

select * from tb where charindex('200',masseq )>0

[navy887]

select * from tb where masseq like '200%'
或select * from tb where left(masseq,3)='200'

[qiqi860819]

where masseq like '200%'

[chenwqi0120]

select * from tb where masseq like '200%'
这是最简单有效的方法

[Zoezs]

整个库的表都搜一便。
EXEC sp_MSForeachtable @command=N'
		select * from [?] 
     ',@whereand='masseq like ''200%''';