Toad World® Forums

exporting to excel


How do i get my exporting data to be reconized by excel as a number an not have to convert it every time?

i have the following line on my sql substr(iinvd.plas_prod_id, 13, 6) and i get this result



Try casting the resulting value as a number. When you substring the value it is a string.