Answer: This function is use to format the value.
The syntax is as under
Format (expression, format [, culture])
e.g.
Select FormattedCurrency = FORMAT(50,'c','ru') ,Dateformat = FORMAT('07/14/2012','yyyy/mm/dd','fr')
/*
FormattedCurrency Dateformat
----------------- ---------
50,00p. 2012/07/14
*/
Asked In: Many Interviews |
Alert Moderator