Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
guys, thanks in advance for any help you can provide.I have a field called firstname, which is in all CAPS. Also it contains first names and middle names. Ex. JOHN PAULI need to combine two scripts that I have. 1)substring(Firstname,1,charindex(' ', Firstname)-1) I'm only concerned about the first name2)firstname = convert(varchar(30),upper(substring(FirstName, 1,1))+lower(substring(FirstName, 2, 30)))I need to get in in proper case.my question, how do i combine both of these into one?again thanks in advance for any help you can provide