Formatting values

Easy to use function based on a character and value parameter. The formatting codes can be used in SSRS with FORMAT(value,FORMAT)


CREATE FUNCTION [dbo].[ValueFormat]
(
 @value float
,@Character varchar(1)
)
RETURNS varchar(12)
AS
BEGIN

DECLARE @valueFormat varchar(12)
SET @valueformat =  (SELECT CASE
 WHEN (@value) < -100000000000 and @Character = '#' THEN '#,##0.00M'
 WHEN (@value) < -1000000000 and @Character = '#'  THEN '#,##0.00M'
 WHEN (@value) < -10000000 and @Character = '#'  THEN '#,##0.00M'
 WHEN (@value) < -1000000 and @Character = '#'  THEN '#,##K'
 WHEN (@value) < -10000 and @Character = '#'  THEN '#,##K'
 WHEN (@value) < -1000 and @Character = '#'  THEN '#,##K'
 WHEN (@value) < -1 and @Character = '#'  THEN '#,##0.00'
   
                      WHEN (@value) < 1 and @Character = '#'  THEN '#,##0.00'
 WHEN (@value) < 10000 and @Character = '#'  THEN '#,##K'
 WHEN (@value) < 1000000 and @Character = '#'  THEN '#,##K'
 WHEN (@value) < 10000000 and @Character = '#'  THEN '#,##0.00M'
 WHEN (@value) < 1000000000 and @Character = '#'  THEN '#,##0.00M'
 WHEN (@value) < 100000000000 and @Character = '#'  THEN '#,##0.00M'

 WHEN (@value) < 0 and @Character = '%' THEN '0.##%'
 WHEN (@value) < 1 and @Character = '%' THEN '0.##%'
 end)
RETURN @valueFormat