CREATE TABLE test(test VARCHAR(20))INSERT INTO dbo.test ( test )SELECT '052000113900001' -- test - varchar(20)UNION ALLSELECT '052000113800001'SELECT *FROM testWHERE SUBSTRING(test,10,1)=9SELECT *FROM testWHERE SUBSTRING(test,10,1)<>9 不知道是不是你要的效果,不是的话再问我吧