SQL Server Convert String to Proper Case (Camel Case) or Title Case Function Example

Introduction:

Here I will explain how to convert string to proper case or title case or camel case in sql server with example. To convert string to proper case or title case in sql server we don’t have any built in function for that we need to create user defined functions to convert string to title case in sql server.

Description:

In previous articles I explained single stored procedure to create, update, delete operations in sql server, SQL Server insert multiple records with one insert statement, SQL Server restore database from .bak / .mdf file,  SQL Server single procedure to insert update delete, SQL Server take database backup, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to convert string to title case in sql server with example.

To call stored procedure from another stored procedure with parameters in sql server follow below steps

Create New Function fn_titlecase in database

create function fn_titlecase(@str as varchar(1000)) returns varchar(1000) as begin declare @bitval bit; declare @result varchar(1000); declare @i int; declare @j char(1); select @bitval = 1, @i=1, @result = ''; while (@i <= len(@str)) select @j= substring(@str,@i,1), @result = @result + case when @bitval=1 then UPPER(@j) else LOWER(@j) end, @bitval = case when @j like '[a-zA-Z]' then 0 else 1 end, @i = @i +1 return @result end

Once you create function in database execute following query it will return data string in title case or proper case or camel case in sql server.

-- Execute this query to convert string to title case / proper case in sql server select dbo.fn_titlecase('hi, welcome to aspdotnet-suresh.com')

If we execute above query we will get output like as shown below

Output

I hope it helps you to convert string to proper case or camel case or title case in sql server.

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email