怎么模糊查询数字字段

[hongt7]

表如下
101
102
103
104
105
106
107
108
109
110
111
201
202
203
204
205
206
207
208
209
209
209
怎么查询出keyindex整型字段中 keyindex为1开头的所有数据？？

[我姓区不姓区]

select keyindex from table where keyindex like '1%'

[yukang_ky]

select * from table where convert(char,keyindex) like '1%'

用系统函数convert将数字字段转换为字符串型，然后在对字符串进行操作

[hongt7]

我把
create procedure select
@index int
as
select keyindex from table where keyindex like '@index%'
为什么查不出来 怎么解决？

[sun_Ke]

你要把数据库字段类型转换下吧

[Coco孙]

[Quote=引用 1 楼 ojlovecd 的回复:]
SQL codeselectkeyindexfromtablewherekeyindexlike'1%'
[/Quote]

[love.李]

create procedure select
@index varchar (10)
as
select keyindex from [table] where keyindex like @index&'%'
试试,

[yukang_ky]

create procedure select1
@index int
as
declare @temp varchar(10)
set @temp=convert(varchar(10),@index)+'%'
select job_Id from jobs where job_Id like @temp
go

[yukang_ky]

create procedure select1
@index int
as
declare @temp varchar(10)
set @temp=convert(varchar(10),@index)+'%'
select keyindex from table where keyindex like @temp
go

[panw520]

[Quote=引用 1 楼 ojlovecd 的回复:]
SQL codeselectkeyindexfromtablewherekeyindexlike'1%'
[/Quote]