quote:

---

Originally posted by stumbling

Hi All
I have a column in a table of type float it contains supplied qty's.
I would like to run the following statement thru a case statment when the value is < 0

SELECT '-' + right(replace(replicate('0', 10) + (cast(qtysupplied as varchar)), '-', ''),10) FROM table_name

Having not used case statements before in any detail i have gotten this far but as someone out there can obviously see i am lost. Any help would be appreciated

select CASE
When qtysupplied > = 0
Then qtysupplied
ELSE (SELECT '-' + right(replace(replicate('0', 10) + (cast(qtysupplied as varchar)), '-', ''),10) FROM table_name)
END
from table_name

---

select 
	CASE 
		When qtysupplied > = 0 Then cast(qtysupplied as varchar)
		ELSE '-' + right(replace(replicate('0', 10) + (cast(qtysupplied as varchar)), '-', ''),10)
END as qtysupplied
from table_name