Posted by SQL on 10/01/79 11:28

It should be done in VB
but you can do it like this

select case field when < 0 then '-' + convert(varchar,field) else '+' +
convert(varchar,field) end MoneyField from TableA

I don't know whatt you want to display for 0.00


http://sqlservercode.blogspot.com/

• Next in forum: Re: Query Help, thanks!
• Prev in forum: Display Money Type using + and -
• Thread view: Re: Display Money Type using + and -

[Reply to this message]