Changing data types

Hi,

I need to change a smallint to text in a Select statement. What's the best way to approach this?

Thanks!

Do you mean something like using the CAST() function?