请教一个sql语句

[blftest1]

现在有vchar类型的字段A B，如果字段A为2 B为5，怎么判断数字3在A和B的范围内。

[發糞塗牆]

先convert(int,a)和convert(int,b)然后再与3between and

[blftest1]

引用 1 楼 DBA_Huangzj 的回复:

先convert(int,a)和convert(int,b)然后再与3between and

能写一下嘛

[blftest1]

引用 1 楼 DBA_Huangzj 的回复:

先convert(int,a)和convert(int,b)然后再与3between and

比如现在有表gongcha字段A B id A B 1 11 22 2 33 44 现在知道有个值为18要求查询出的结果为 id A B 1 11 22 select * from gongcha where A<=18 and 18<=B 这个没办法比较

[發糞塗牆]

select * from tb where 3 between convert(int,a) and convert(int,b)

[MrYangkang]

select * from t1 where 3 between convert(int,a) and convert(int,b)

[blftest1]

引用 4 楼 DBA_Huangzj 的回复:

select * from tb where 3 between convert(int,a) and convert(int,b)

好像mysql不能用

[MrYangkang]

select * from gongcha where 18 between convert(int,a) and convert(int,b)

[發糞塗牆]

mysql你发来SQLServer干嘛？