Split words with a capital letter in sql

by

Here is a function I created that is similar to the “removing non-alphabetic characters”. How to strip all non-alphabetic characters from string in SQL Server?

This one uses a case sensitive collation which actively seeks out a non-space/capital letter combination and then uses the STUFF function to insert the space. This IS a scalar UDF, so some folks will immediately say that it will be slower than other solutions. To that notion, I say, please test it. This function does not use any table data and only loops as many times as necessary, so it will likely give you very good performance.

Create Function dbo.Split_On_Upper_Case(@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin

    Declare @KeepValues as varchar(50)
    Set @KeepValues="%[^ ][A-Z]%"
    While PatIndex(@KeepValues collate Latin1_General_Bin, @Temp) > 0
        Set @Temp = Stuff(@Temp, PatIndex(@KeepValues collate Latin1_General_Bin, @Temp) + 1, 0, ' ')

    Return @Temp
End

Call it like this:

Select dbo.Split_On_Upper_Case('OneTwoThreeFour')
Select dbo.Split_On_Upper_Case('OneTwoThreeFour')
Select dbo.Split_On_Upper_Case('One')
Select dbo.Split_On_Upper_Case('OneTwoThree')
Select dbo.Split_On_Upper_Case('stackOverFlow')
Select dbo.Split_On_Upper_Case('StackOverFlow')

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Get top 1 row of each group
  3. How to return only the Date from a SQL Server DateTime datatype
  4. How to calculate age (in years) based on Date of Birth and getDate()
  5. CROSS JOIN vs INNER JOIN in SQL
  6. Referring to a Column Alias in a WHERE Clause
  7. Convert Month Number to Month Name Function in SQL
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. Limit on the WHERE col IN (…) condition
  10. Removing leading zeroes from a field in a SQL statement
  11. Generate a resultset of incrementing dates in TSQL
  12. converting Epoch timestamp to sql server(human readable format)
  13. Getting result of dynamic SQL into a variable for sql-server
  14. How to get difference between two rows for a column field?
  15. Better techniques for trimming leading zeros in SQL Server?
  16. How do I split a delimited string so I can access individual items?
  17. Common Table Expression, why semicolon?
  18. T-SQL split string based on delimiter
  19. SQL Server SELECT into existing table
  20. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  21. Why use Select Top 100 Percent?
  22. Correct use of transactions in SQL Server
  23. How do I prevent a database trigger from recursing?
  24. What is the Null Character literal in TSQL?
  25. How to create a pivot query in sql server without aggregate function
  26. TSQL – How to use GO inside of a BEGIN .. END block?
  27. SQL take just the numeric values from a varchar
  28. Cumulative Total in MS Sql server [duplicate]
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment