Hi Kevin4u06,

You can write a function to solve your problem. This is function code:

CREATE FUNCTION [dbo].[format_currency] (@monetary_value decimal(20,2) ) returns varchar(20)

as

begin

declare @return_value varchar(20)

declare @is_negative bit

select @is_negative = case when @monetary_value<0...