What is I just want to just convert the first letter in uppercase? What do i do?

Answer 1

.

Answer 2

It is called as Camel Case in all languages you can just Search on Google about using Camel Case on sql

Answer 3

if you want just the first letter in the string you can do the following:

select concat (upper (left ([colName],1)),substring ([colName],2,len ([colName]))) from [tableName]

it works by -

selecting the first letter using the left function for 1 character combined with the builtin upper function.
upper (left ([colName],1))

we then get the rest of the string by using substring which starts at character 2 and gets characters for the length of the string.

using concat the results are joined to give you the answer.

camel case will require a bit more work.

Answer 4

thanks to both of you! 😁