Home > IT Answers > AS/400 > Converting a varchar to a numberic in SQL query
AS400 - Ask the Expert
485 pts.
 Converting a varchar to a numberic in SQL query
AS/400, DB2, DB2/400, SQL Query, VARCHAR
How can we convert a varchar field to Numberic in a SQL Query in db2 400?

Software/Hardware used:
ASKED: November 4, 2008  5:50 PM
UPDATED: December 4, 2008  2:04 AM
RELATED QUESTIONS
Answer Wiki:
Does this do it? dec(odptn ) How about using SQL functions: INTEGER(varchar_column) The same can be done to other DB2 numeric data types.
Last Wiki Answer Submitted:  December 4, 2008  2:04 am  by  philpl1jb   44,190 pts.
All Answer Wiki Contributors:  philpl1jb   44,190 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _