摘要： -- '%[^a-z]%'CREATE Function [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(1000))Returns VarChar(1000)ASBegin While PatIndex('%[^a-z]%', @Temp) > 0 Set @Temp = Stuff(@Temp, PatIndex('%[^a-z]%', @Temp), 1, '') Return @TEmpEnd-- '%[^a-z0-9]%'CREATE Function 阅读全文