firstname = convert(varchar(30),substring(upper(substring(FirstName, 1,1))+lower(substring(FirstName, 2, 30)) ,1,charindex(' ', Firstname)-1))

firstname = LEFT(FirstName, 1) + LOWER(SUBSTRING(FirstName, 2, CHARINDEX(' ', Firstname) - 2))

quote:

---

Originally posted by malpashaa

You can combine them like this:

firstname = convert(varchar(30),substring(upper(substring(FirstName, 1,1))+lower(substring(FirstName, 2, 30)) ,1,charindex(' ', Firstname)-1))

But a simpler way would be:

firstname = LEFT(FirstName, 1) + LOWER(SUBSTRING(FirstName, 2, CHARINDEX(' ', Firstname) - 2))

For us, there is only the trying. The rest is not our business. ~T.S. Eliot

Muhammad Al Pasha

---