Re: Writing in all caps

[Mario Insigne <minsigne@CCSF.CC.CA.US>]

If your are selecting columns from the table, you can do it like:

  begin-select
  upper(column_name) &colname
  upper(column_name2) &colname2
  end-select

Mario

On Tue, 11 Nov 1997, Budzinski, Robert wrote:

> The way I do it is I create a Assign-Values procedure to do all the
> formating before I write the file.  In the proc I use something like
> this:
>
>       let  $w_DC.last_name          = upper($LastName)
>       let  $w_DC.first_name         = upper($FirstName)
>       let  $w_DC.middle_init        = upper($MidInitial)
>
> This works for me, but there may be a better way.
>
>
> >----------
> >From:  Susannah Wells[SMTP:susannah_wells@PAGENET.COM]
> >Sent:  Tuesday, November 11, 1997 1:30 PM
> >To:    Multiple recipients of list SQR-USERS
> >Subject:       Writing in all caps
> >
> >Does anyone know how to write your output file in all caps?
> >
> >TIA,
> >Susannah Wells
> >Software Engineer
> >Paging Network, Inc.
> >Work 972-985-6352
> >Pager 214-835-9638, Dallas Pin 0 005-3565
> >Internet susannah_wells@pagenet.com
> >
>