Database Developer Question:
Download Questions PDF

Please explain what are string functions in SQL?

Database Developer Interview Question
Database Developer Interview Question


SQL string functions are used primarily for string manipulation. Some of the widely used SQL string functions are

☛ LEN() – It returns the length of the value in a text field
☛ LOWER() – It converts character data to lower case
☛ UPPER() – It converts character data to upper case
☛ SUBSTRING() – It extracts characters from a text field
☛ LTRIM() – It is to remove all whitespace from the beginning of the string
☛ RTRIM() – It is to remove all whitespace at the end of the string
☛ CONCAT() – Concatenate function combines multiple character strings together
☛ REPLACE() – To update the content of a string.

Download Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what are DMVs?What are the steps needed to Create the scheduled job?