Database Developer Question:
Download Questions PDF

Please explain what are string functions in SQL?

Database Developer Interview Question
Database Developer Interview Question

Answer:

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?