Column Seperate

[Amila]

Dear Friends Kindly Help Me how to Separate Amount Column to 02 column as if its + value column name as credit if value - column name as debit

[Amila]

Please anyone Kindly Help

[harishgg1]

not able to understand you

can you show an example

[Amila]

Thanks For the Reply
i want to divide (+) values another column and (-) values to another column

[Amila]

output as

[harishgg1]

[Amila]

null

[Amila]

Dear Friend Kindly Send me the Full Query Statement how to separate way

[harishgg1]

amount + isnull(credit,0) as debit

[Amila]

How to Separate Amount Column values to Credit and Debit Column
i need to know that

[Ifor]

,CASE WHEN Amount >= 0 THEN Amount END AS Credit
,CASE WHEN Amount < 0 THEN ABS(Amount) END AS Debit

[Amila]

Thanks Brother!!!!!!!