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 , …………);

sql concat function

 Syntax - 

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

sql concat function


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 reverse function

SQL CHARACTER LENGTH FUNCTION 

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


Syntax -

select char_length (‘ any character’);

sql character length function

SQL UPPER CASE FUNCTION 

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


Syntax -

select upper (' any character ');

sql upper case function

SQL LOWER CASE FUNCTION 

This is used to write lower words to upper word. 

Syntax -

select lower (' any charecter ');

sql lower case function