select a.USER_ID,a.USER_NAME,b.ACCOUNT_FEE,a.CREATE_TIME,a.ADDRESS,a.TELEPHONE,a.MOBILE
from USERINFO a left join ACCOUNT_INFO b
ON a.USER_ID = b.ACCOUNT_ID
where substring(rtrim(a.USER_ID),6,1)='6'
order by USER_ID
from USERINFO a left join ACCOUNT_INFO b
ON a.USER_ID = b.ACCOUNT_ID
where substring(rtrim(a.USER_ID),6,1)='6'
order by USER_ID
from USERINFO a left join ACCOUNT_INFO b
ON a.USER_ID = b.ACCOUNT_ID
where substring (USER_ID, 6 ,1 ) = '6'
order by USER_ID
from USERINFO a left join ACCOUNT_INFO b
ON a.USER_ID = b.ACCOUNT_ID
where substring (rtrim(USER_ID), 6 ,1 ) = '6'
order by USER_ID
from USERINFO a left join ACCOUNT_INFO b
ON a.USER_ID = b.ACCOUNT_ID
where SUBSTRING(CONVERT(varchar(100),a.user_id),6,1)='6'--先转化为字符型 再取出第六个
order by USER_ID