Re: Convert VARCHAR to INT

Phoenix stores VARCHAR and INTEGER values differently so your best bet is to create a new INTEGER column and write a script to move data from the VARCHAR column into the INTEGER column. If you are guaranteed that all data in your VARCHAR column are indeed numbers you can do this with a single SELEC

Convert VARCHAR to INT

Is it possible to convert a VARCHAR to int in phoenix ? If yes, can you please help me out with the way to do it. Regards, Imran A Mohammed.