Menu
What is the T-SQL function for converting strings into upper case in SQL Server?
490
The UPPER() function converts a string to upper-case.
In SQL Server, you can convert any lowercase string to uppercase by using the UPPER() function. To use it, simply pass the string as an argument when calling the function.
Use the INITCAP() function to convert a string to a new string that capitalizes the first letter of every word. All other letters will be lowercase. This function takes one parameter as a string and changes the capitalization for each word as described.
UPPER() : This function in SQL Server helps to convert all the letters of the given string to Uppercase. If the given string contains special characters or numeric values, then they will remain unchanged by this function. Syntax : UPPER( str )
UPPER
SELECT UPPER(LastName) + ', ' + FirstName AS Name FROM Person.Person If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
