Skip to main content

Posts

Showing posts from April, 2023

Split a string based on Capital letters in a string

 CREATE FUNCTION dbo.Split_On_Upper_Case  (      @String VARCHAR(4000)  ) RETURNS VARCHAR(4000) AS BEGIN DECLARE @Char CHAR(1); DECLARE @i    INT = 0; DECLARE @OutString VARCHAR(4000) = ''; WHILE (@i <= LEN(@String)) BEGIN     SELECT @Char = SUBSTRING(@String, @i,1)     IF (@Char = UPPER(@Char) Collate Latin1_General_CS_AI)         SET @OutString = @OutString + ' ' + @Char;     ELSE         SET @OutString = @OutString +  @Char;      SET @i += 1; END  SET @OutString =  LTRIM(@OutString);  RETURN @OutString; END