Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --SELECT dbo.StripNonNumerics(Item) FROM Items
- CREATE FUNCTION [dbo].[StripNonNumerics]
- (
- @Temp varchar(255)
- )
- RETURNS varchar(255)
- AS
- Begin
- Declare @KeepValues as varchar(50)
- Set @KeepValues = '%[^0-9]%'
- While PatIndex(@KeepValues, @Temp) > 0
- Set @Temp = Stuff(@Temp, PatIndex(@KeepValues, @Temp), 1, '')
- Return @Temp
- End
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement