Web Development
create function [dbo].[fn_stripNonAlpha](@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
No comments:
Post a Comment