如何从 SQL Server 中的字符串中去除所有非字母字符?

2021-12-02 00:00:00 parsing user-defined-functions sql-server alphanumeric alphabetic

如何从字符串中删除所有非字母字符?

How could you remove all characters that are not alphabetic from a string?

非字母数字呢?

这是否必须是自定义函数，还是有更通用的解决方案?

Does this have to be a custom function or are there also more generalizable solutions?

推荐答案

试试这个功能:

Create Function [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin

    Declare @KeepValues as varchar(50)
    Set @KeepValues = '%[^a-z]%'
    While PatIndex(@KeepValues, @Temp) > 0
        Set @Temp = Stuff(@Temp, PatIndex(@KeepValues, @Temp), 1, '')

    Return @Temp
End

这样称呼它:

Select dbo.RemoveNonAlphaCharacters('abc1234def5678ghi90jkl')

一旦你理解了代码，你应该会看到改变它以删除其他字符也是相对简单的.您甚至可以将其设置为足够动态以传递您的搜索模式.

Once you understand the code, you should see that it is relatively simple to change it to remove other characters, too. You could even make this dynamic enough to pass in your search pattern.

希望有帮助.

相关文章