union后的根据字符长度排序

来源:互联网 发布:淘宝查号kehuda 编辑:程序博客网 时间:2024/05/02 02:55

select top 10 * from(select cname from pricelist where cname LIKE '%"&keyword&"%' and cname not in ('"&keyword&"')
union select Number from pricelist where Number LIKE '%"&keyword&"%' and Number not in ('"&keyword&"')) t
order by len(cname)