Posted on Leave a comment

Title Case / Proper Case

CREATE FUNCTION [dbo].[fnTitleCase]( @text AS varchar(8000) )
RETURNS varchar(8000)
AS
BEGIN
DECLARE @Reset bit;
DECLARE @Ret varchar(8000);
DECLARE @i int;
DECLARE @c char(1);

SELECT @Reset = 1, @i=1, @Ret = '';

WHILE (@i

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.