Skip to content

Instantly share code, notes, and snippets.

@grishin

grishin/remove_non_alpha_characters.sql

Created January 30, 2014 11:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save grishin/8706957 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save grishin/8706957 to your computer and use it in GitHub Desktop.
Download ZIP
How to clean SQL string
Raw
remove_non_alpha_characters.sql
CREATE Function [dbo].[fn_cc2RemoveNonAlphaCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin
While PatIndex('%[^a-z]%', @Temp) > 0
Set @Temp = Stuff(@Temp, PatIndex('%[^a-z]%', @Temp), 1, '')
Return @TEmp
End
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment