convert currency sql

(
@Amount DECIMAL(18,2),
@Freight DECIMAL(18,2),
@FreightName VARCHAR(500)

)
AS
SELECT FreightName,

CASE WHEN (FreightName= @FreightName) And (UseFreight = 'TRUE') THEN
'$' + Convert(varchar(25), @freight,1
ElSE
'$' + Convert(varchar(25), 0.00,1
END AS Freight
FROM
tblFreightType
WHERE FreightName=@FreightName

when i execute the query it says cant convert varchar to numeric

I think you left your trailing ) off your Convert Calls

Code:

---

'$' + Convert(varchar(25), @freight,1
ElSE
'$' + Convert(varchar(25), 0.00,1

---

Should be

Code:

---

'$' + Convert(varchar(25), @freight,1)
ElSE
'$' + Convert(varchar(25), 0.00,1)

---

I assumed that was a copy and paste error but I cannot recreate your bug.
This is what I tried

Code:

---


declare @tblFreightType table (FreightName VARCHAR(500))
insert into @tblFreightType values ('UPS')

declare @Amount DECIMAL(18,2)
declare @Freight DECIMAL(18,2)
declare @FreightName VARCHAR(500)
set @FreightName = 'UPS'
set @Freight = '2.32'

SELECT FreightName,

CASE WHEN (FreightName= @FreightName)  THEN
'$' + Convert(varchar(25), @freight,1)
ElSE
'$' + Convert(varchar(25), 0.00,1 )
END AS Freight

FROM
@tblFreightType
WHERE FreightName=@FreightName

---

Maybe try Cast?

thank you very much thetimmer

my pleasure, glad you got it worked out.
Remember to mark this thread resolved if it's working for you now.