Re: CAST(integer_field AS character) truncates trailing zeros

On Thu, Jul 31, 2008 at 4:03 PM, Warren Bell <warren@clarksnutrition.com> wrote:
> I am trying to cast an int to a character. The int is the number 1000 it
> gets cast down to "1" and not "1000". How do I cast from int to character
> without loosing the trailing zeros?

Please supply the exact syntax that you're using to do the cast.

-Doug