create table tb(xingming varchar(10)) insert into tb values('张三') insert into tb values('李四232') insert into tb values('万个a') goselect * from tb where right(xingming,1) between '吖' and '咗'drop table tb/* xingming ---------- 张三(所影响的行数为 1 行) */
select * from tb where len(right(xingming,1))<datalength(right(xingming,1))
insert into tb values('张三')
insert into tb values('李四232')
insert into tb values('万个a')
goselect * from tb where right(xingming,1) between '吖' and '咗'drop table tb/*
xingming
----------
张三(所影响的行数为 1 行)
*/
比如其他排序规则就要相应更改