justifying

Posted in 1999

Min Kim — Wed, 26 May 1999 12:57:38 -0400 — source: Informix-list mailing list archive (1991-1998)

hi, does anyone know how to align an INT or SMALLINT to the left as far as possible? I want to cat a string and an int, but I get results like: ThisIsMyString 5 The space is undesirable since I'm naming indexes on the fly. Min

↪ replying to Min Kim

robertb..vorbroker — Wed, 26 May 1999 17:44:03 GMT — source: Informix-list mailing list archive (1991-1998)

LET l_index = "ThisIsMyString", l_int USING "<<<<<" Number of < depends on whether you are using a SMALLINT or INTEGER... Rob Vorbroker Min Kim <mkim@icpma.com> wrote in message news:374C2801.CC1C41B0@icpma.com... > hi, > does anyone know how to align an INT or SMALLINT to the left as far as > possible? > I want to cat a string and an int, but I get results like: > ThisIsMyString 5 > The space is undesirable since I'm naming indexes on the fly. > > Min >

↪ replying to Min Kim

Art S. Kagel — Wed, 26 May 1999 15:02:45 -0400 — source: Informix-list mailing list archive (1991-1998)

Min Kim wrote: > > hi, > does anyone know how to align an INT or SMALLINT to the left as far as > possible? > I want to cat a string and an int, but I get results like: > ThisIsMyString 5 > The space is undesirable since I'm naming indexes on the fly. Are you selecting these from some table? Try concatenation: SELECT trim(colname) || colno FROM syscolumns; Art S. Kagel

↪ replying to Min Kim

Min Kim — Thu, 27 May 1999 08:21:48 -0400 — source: Informix-list mailing list archive (1991-1998)

Nevermind on this one. I just assigned the INT to a STRING and all went well. Min Min Kim wrote: > hi, > does anyone know how to align an INT or SMALLINT to the left as far as > possible? > I want to cat a string and an int, but I get results like: > ThisIsMyString 5 > The space is undesirable since I'm naming indexes on the fly. > > Min