What are the manipulation functions in SQL

Question

Hi!!

Can someone list the various manipulative functions in SQL?

Answer 1

There are three case manipulation functions in SQL, namely:

• LOWER: This function returns the string in lowercase. It takes a string as an argument and returns it by converting it into lower case. Syntax:

 LOWER(‘string’)

• UPPER: This function returns the string in uppercase. It takes a string as an argument and returns it by converting it into uppercase. Syntax:

UPPER(‘string’)

• INITCAP: This function returns the string with the first letter in uppercase and rest of the letters in lowercase. Syntax:

 INITCAP(‘string’)