SQL Functions

SQL CONCAT( ) FUNCTION

 The concat( ) function add two or more expression together. 

For add two or more expressions from column 

Syntax -

 Select Concat (expression1 , expression2 , expression3 , …………);

Syntax - 

select concat ( column_name1, ' ', column_name2, ' ' , ……….. ) from table_name as fullname; 

SQL REVERSE ( ) FUNCTION

 The reverse function uses to write anything reversely. 

Syntax -

select reverse ( ‘write any string’ );

or 

select reverse ( ‘write any string’ ) as reverse ;

SQL CHARACTER LENGTH FUNCTION 

This is used to count the length of words, numbers etc. 

Syntax -

select char_length (‘ any character’);

SQL UPPER CASE FUNCTION 

This is used to write lower words to the upper word.

Syntax -

select upper (' any character ');

SQL LOWER CASE FUNCTION 

This is used to write lower words to upper word. 

Syntax -

select lower (' any charecter ');