求助 筛选排序问题

flyknife8

<COLGROUP>

<COL style="WIDTH: 54pt" width=72>





1



11



111



121



11111



11221



11211



12223



1123



11111



1521



1321



1245



1687...........这样一组数字  如何把尾数为1的数字筛选出来?排成下边的样子



<COLGROUP>

<COL style="WIDTH: 54pt" width=72>





1



11



111



121



1321



1521



11111



11211



11221

wwwwa

try:

SELECT trim(str(dd)) from a108 where mid(trim(str(dd)),len(trim(str(dd))),1)=1 order by dd;

hi-wzj

条件用 like “*1"

wwwwa

or

SELECT trim(str(dd))
FROM a108
WHERE dd like '*1'
ORDER BY dd;