HELP !!!

[hameja]

Dear all
How can I sum a character filed
example

 

[lewisp]

That is a very good question. How can you if it is character?

Are you saying your character field only contains numbers? Can you guarantee this? If so, look at using TO_NUMBER.

 

[hameja]

Is coming wioth an error invalid number

look at this
select distinct(ltrim(method)) "METHOD",
substr(datehourmin,1,8) "DATE"
to_num(currency)
from min_in
group by method,substr(datehourmin,1,8)

I want to sum on this field.

John

 

[Turkbear]

Hi,
SUM on What field - to_num(currency) ? Is Currency a character field? - Always?

What error?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hameja]

Yes currency is a varchar

error invalid number

 

[Turkbear]

OK,
That means the one of more of the records has a non-numeric character in the currency field, so you would need to correct the data or exclude those records.

After that , you should be able to use the Sum(to_num(currency)) function in your query..






To Paraphrase:"The Help you get is proportional to the Help you give.."