How do i convert VARCHAR to INT in DB2

gsinha · #1 (**permalink**) 11-18-03, 16:26

Hello All

I would like to have a script that would convert VARCHAR to INT in DB2

I am new to Db2 and any help will be of great help to me

Thanks

Gautam S

n_i · #2 (**permalink**) 11-18-03, 16:40

Quote:

Originally posted by gsinha
Hello All

I would like to have a script that would convert VARCHAR to INT in DB2

I am new to Db2 and any help will be of great help to me

Thanks

Gautam S

Look at INTEGER() function

Marcus_A · #3 (**permalink**) 11-18-03, 18:49

You can also use:

CAST(column-name AS INT)

But you will get a data exception error if the value is not numeric.

Internet Services

Web Development

Digital Marketing

Consumer Tech