Select * From Table1
where right(aa,1)>3Select * From Table1
where cast(right(cast(aa as varchar(10)),1) as int)>3上述语句均在SQL2000英文版, Windows2000英文版下调试通过!!!
上述语句均在SQL2000英文版, Windows2000英文版下调试通过!!!
where right(aa,1)>3Select * From Table1
where cast(right(cast(aa as varchar(10)),1) as int)>3上述语句均在SQL2000英文版, Windows2000英文版下调试通过!!!
上述语句均在SQL2000英文版, Windows2000英文版下调试通过!!!
sql server通过