split a char from a string

Question

Hi How to split a char from the following string using SQlSERVER 100.00 kl 45.00 kl 4.45 kl I want my OutPut as : 100.00 45. 00 4.45

Shankey · Answer

Hi syed Following is the sql code to get what you want: But donot forget to mark my answer as accepted if it helped you. :) DECLARE @position int @string nvarchar(max)@AsciiValue INT SET @position = 1 SET @AsciiValue=0 SET @string = '100.00 kl' DECLARE @TString nvarchar(max) SET @TString = '' WHILE @position BEGIN SELECT @AsciiValue=ASCII(SUBSTRING(@string @position 1)) if ((@AsciiValue >= 48 AND @AsciiValue begin SET @TString =@TString + SUBSTRING(@string @position 1) end SET @position = @position + 1 END PRINT 'Input String:' + @string PRINT 'Output String:' + @TString Output: Input String:100.00 kl Output String:100.00