Guys,
I have a select statement ere one of the field has a negative value.
How do i convert it into zero in select statement.
;with CTE as
(
Select
Itemid
,AVAILORDERED as OnHandQty - just want to convert some negative result into 0
From MyTable
)
Select * from CTE
Thank you in advance..
jov