SELECT ' ' + UPPER(LEFT(fname, 1)) + LOWER(SUBSTRING(fname, 2, LEN(fname)))

+ ' ' + UPPER(LEFT(lname, 1)) + LOWER(SUBSTRING(lname, 2, LEN(lname)))

AS 'Full Name'

FROM dbo.mReg_Table

-- By Nilesh Umaretiya

-----------------------

Software Engineer

UIPC, Satellite,

Ahmedabad-15

Gujarat, India