create table #temp( testvarchar(20) );INSERT INTO #temp VALUES('我是中国人0001');goSELECTConvert(char(8), test) AS [0to8],Convert(char(14), test) AS [0to14], RIGHT(Convert(char(14), test), LEN(Convert(char(14), test)) - LEN(Convert(char(8), test))) AS [8to14]FROM #tempGO0to8
0to14
8to14-------- -------------- -... |
