查找学号为0002的学生
[sql]
select * from Student where replace(ltrim(replace(stuNo,'0',' ')),' ','0')='2'
www.2cto.com
[sql]
values(replace(ltrim(replace('0000123.100','0',' ')),' ','0'))
作者
aspnet2002web