Convert varchar to Money 1

[richrich05]

I'm trying to convert a varchar field into a money but I'm running into problems because the column contains some rows that are credits that have () around them. The expression I'm trying is listed below.

Select cast(E_Amt As Money) AS Amount
From Tbl_Expenses
Oder by E_Amt


Your help would be truly appreciated.

 

[tran008]

not sure if this the best way to write this...
Select cast(replace(replace(E_Amt,')',''),'(','') As Money) AS Amount
From Tbl_Expenses
Oder by E_Amt

 

[richrich05]

Niceeee That worked perfect, I didn't even think of wirting it that way.