Data Conversion in DB2

Jaraba

Can someone point to a good source of information for converting data
types in DB2?

i.e. string to integers, etc

Apr 27 '06 #1

Mark A

"Jaraba" <fg*****@tampabay.rr.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

Can someone point to a good source of information for converting data
types in DB2?

i.e. string to integers, etc

Look as the CAST function in SQL Reference Vol 1.

Apr 27 '06 #2

Mehmet Baserdem

select sum(cast(mycol as integer)) from mytable

regards

Mehmet

Apr 27 '06 #3