Re: SQL*REP - how to Center-Justify a variable

fragante_at_unixg.ubc.ca (Gv Fragante) writes:

>I am trying to Center-Justify a variable. This variable is defined as 80
>characters long and I have specified CENTER in the alignment option. However,
>this still does not center the variable - it is always left-justified.
 

>I tried trimming any trailing blanks and this still did not work. Am I missing
>something here to make the CENTER alignment work ?
 

>Thanks.

  I think CENTERing just centers the variable not the contents of it. For   example, if you had EMP_NUM as CHAR(10) and centered that, it would   center the whole field.

  Perhpas in your SELECT statement you can do some fancy SUBST   work and alias the result. The use the alias and center it.

  Something like:

  SELECT attr1, attr2, attr3, SUBST(big_attr,1,LENGTH(big_attr)) BIG_A,

         attr4, attr5
  FROM . . .   The NEW name for the attribute becomes BIG_A and you can refer to   that in the rest of the report.

Rich Holowczak holowcza_at_andromeda.rutgers.edu Rutgers University
Ph.D. Computers and Information Systems Program "Availability of Distributed Databases During Network Partitioning"

+---------------------------------------------------+---------------+
| The .sig, the whole .sig and nothing but the .sig | Ask about the |
|           <<< This space for rent >>>             | car alarm FAQ |
+---------------------------------------------------+---------------+