示例：
SELECT SUBSTRING(Column1,1,4) + SUBSTRING(Column1,4,3) AS Col1 FROM MyTable WHERE Col1 = 'MySearch'
我使用MSsql 2005
SELECT SUBSTRING(Column1,3) AS Col1 FROM MyTable WHERE SUBSTRING(Column1,3) = 'MySearch'
不需要子查询或黑客
