What functions have you used ? How would you use these functions : Coalesce, delete, truncate, UDF, Charindex:

What functions have you used ?  How would you use these functions : Coalesce, delete, truncate, UDF, Charindex:

 I used UDF’s and many aggregate functions.

I used these functions for;

Coalesce= It is used for two or more than two attributes to change the value .It is same as case statement in sql  . For example 

COALESCE(columnName1,ColumnName2,ColumnName3)

--WHEN (columnName1 IS NOT NULL) THEN columnName2 ,If (columnName1  IS  NULL) THEN it will check columnname2 and so on.