Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Create Function dbo.SpaceUpper(@Original VarChar(8000))
Returns VarChar(8000)
As
Begin
While PatIndex('%[^ ][A-Z]%', @Original Collate Latin1_General_Bin) > 0
Set @Original = Replace(@Original Collate Latin1_General_Bin, SubString(@Original, 1+PatIndex('%[^ ][A-Z]%', @Original Collate Latin1_General_Bin), 1), ' '+ SubString(@Original, 1+PatIndex('%[^ ][A-Z]%', @Original Collate Latin1_General_Bin), 1))
Return LTrim(@Original)
End
Select dbo.SpaceUpper('ThisIsTheDescription')
Select Column1,
dbo.SpaceUpper(Column2) As ColumnX
From YourTableName