> -----Original Message-----
> From: Roger Hall
> Sent: Wednesday, March 03, 1999 9:27 AM
> To:   [log in to unmask]
> Subject:      RE: SQL Help (PLEASE)!
>
> SELECT ORDER_NO FROM SHIPS.ORDER_HEADERS WH WHERE ORDER_NO >
> '90000000';
> --------
>
> ORDER_NO
>
> --------
>
> UA29JH00
> U8241100
> U8241000
> UA29J400
> U8240900
> U8240800
> U8240700
> UA29J300
> UA29J200
> UA29J100
> UA29J000
> U8243700
> U8262400
> UA29IW00
> UA29IV00
> UA29IU00
> ----------------------------------------------------------------------
> -----
> First 16 rows have been selected.
> U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]
> >
>
> Use the pipe-pipe to concatenate two fields or a value to a field.
>
>
>
> SELECT (ORDER_NO || 'A1') FROM SHIPS.ORDER_HEADERS WH WHERE ORDER_NO >
> '90000000';
>
> returns:
>
> ----------
>
> UA29JH00A1
> U8241100A1
> U8241000A1
> UA29J400A1
> U8240900A1
> U8240800A1
> U8240700A1
> UA29J300A1
> UA29J200A1
> UA29J100A1
> UA29J000A1
> U8243700A1
> U8262400A1
> UA29IW00A1
> UA29IV00A1
> UA29IU00A1
> ----------------------------------------------------------------------
> -----
> First 16 rows have been selected.
>
>
> -----Original Message-----
> From: [log in to unmask] [SMTP:[log in to unmask]]
> Sent: Wednesday, March 03, 1999 9:24 AM
> To:   Roger Hall
> Subject:      RE: SQL Help (PLEASE)!
>
>
>
> Must be SQL (sigh) :{, thanks though.
>
>
>
>
>
> Roger Hall <[log in to unmask]> on 03/03/99 09:09:37 AM
>
>
> To:   Jeff L. Keepers/VQ-Valley/3M/US
> cc:
> Subject:  RE: SQL Help (PLEASE)!
>
>
>
>
> Must be SQL? No SuprTool? :{
>
> > -----Original Message-----
> > From:   Jeff Keepers [SMTP:[log in to unmask]]
> > Sent:   Wednesday, March 03, 1999 9:11 AM
> >
> > Does anyone have any ideas (must be in SQL)?  Please send responses
> to
> > [log in to unmask] since I currently just receive a digest version of
> > the
> > postings.
> >
> >
>
>
>