Re: Data conversion

Posted in 1999

Vardan.Aroustamian@chase.com — Tue, 4 May 1999 12:09:50 -0400 — source: Informix-list mailing list archive (1991-1998)

Wilson Kwan wrote: > > Hello! > > I am running Informix online 5.0. > > Does anyboy know how to conver numeric to character in store procedure? > > In 4gl program, can use > let char = numerbic using "##,###", > but in store procedure, show syntex error message. > Just remove 'using' part. But you probably want to format output. Well, maybe it's better to do in 4gl, than in stored procedure? Anyway, e.g. if numerbic > 9999 then let other_char = numerbic let char = other_char[1,2] || ',' || other_char[3,5] end if HTH Vardan Aroustamian > Thank you, > > Wilson Kwan > > -- vaar@geocities.com