Hi folks, I’ve changed the t-sql code for Capitalize function, the previous capitalize function worked only if there is one space between words, but this version works even if there be more than one space between words. with this version of Capitalize; you can run the function like this: select dbo.Capitalize(‘st    charles‘) and this Read more about Capitalize Function (Version 2.0) – T-SQL[…]

T-SQL code (working in SQL Server) to replace duplicate spaces (or triple or more) with a single space is : declare @text varchar(max) set @text=’ St    Charles’ while charindex(‘  ‘,@text)>0 set @text=replace(@text,’  ‘,’ ‘) select @text and the result is : St Charles 

Hi folks, Today I faced a situation that I need to capitalize sentences in one column of a SQL Server database table, so I created a function to do that, I put this here to share with you. this function will change sentences like  : select dbo.Capitalize(‘sample text for capitalization!‘) to : Sample Text For Capitalization! Here Read more about T-SQL Function for Capitalize Word and Sentences[…]