TSQL Beginners Challenge 22 - Create SQL Server version of the ORACLE INITCAP function - Solution to TSQL Beginners Challenge 22

Getting Started with Adobe After Effects - Part 6: Motion Blur


	TSQL Beginners Challenges

Upload Image

Close it

Select File

This challenge to is implement similarly functionality in TSQL, that works similar to INITCAP function of ORACLE.


	Like

Invite Friends

TSQL Beginners Challenge 22 - Create SQL Server version of the ORACLE INITCAP function

Home · Challenge Details · Comments · Solutions · Fans (45) · Preferences

Solution to TSQL Beginners Challenge 22

Oct 11 2011 2:36PM by vdr

Solution to TSQL Beginners Challenge 22

DECLARE @t TABLE(ID INT IDENTITY, Data VARCHAR(100))

INSERT INTO @t
SELECT 'welcome to TSQL Challenge #22'

SELECT *, REPLACE(Data,SUBSTRING(data,1,1),UPPER(SUBSTRING(Data,1,1)))  FROM @t

Tags:

vdr

1060 · 0% · 24

Liked


Post this to my facebook wall
Tweet this
Like this


	Submit

Your Comment

Sign Up or Login to post a comment.

TSQL Beginners Challenge 22 - Create SQL Server version of the ORACLE INITCAP function

Solution to TSQL Beginners Challenge 22

Your Comment