查找学号为0002的学生
select * from Student where replace(ltrim(replace(stuNo,'0',' ')),' ','0')='2'
replace(
ltrim(replace(stuNo,'0',' ')),' ','0') ,首先replace(stuNo,'0',' ')部分把所有的0替换为空格,然后用ltrim删除所有左侧的空格,最后把剩余的空格替换为0
values(replace(ltrim(replace('0000123.100','0',' ')),' ','0'))