sql??if substring(convert(xxx,xxx),4,1)<>"值" begin --sql代码 go
select .... where SUBSTRING(au_fname, 4, 1)=x
v列数字 11000 12000 13000 14000 113000 111111 323000 232000 333000 4544444 4444444 select v from t where SUBSTRING(CAST(v AS varchar(16)),(LEN(CAST(v AS varchar(16)))-3),1)='3' 查找右边4位为等于3的记录 13000 113000 323000 333000
SELECT SUBSTRING(REVERSE(字段名), 4, 1) AS Expr1 FROM 表名
begin
--sql代码
go
11000
12000
13000
14000
113000
111111
323000
232000
333000
4544444
4444444
select v from t where SUBSTRING(CAST(v AS varchar(16)),(LEN(CAST(v AS varchar(16)))-3),1)='3'
查找右边4位为等于3的记录
13000
113000
323000
333000