[SQL] Returning String as Integer

[Kashmira Patel \(kupatel\)]

Hi all,

   I have a table with a column of type 'text'. It mainly contains numbers. Is there any way to select a value from this column and return it as an integer?

 

Thanks,

Kashmira