Re: Combining fields

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 31 Mar 2001 00:20:02 +0200
Message-ID: <tca1gq3ndk4852@beta-news.demon.nl>

Refer to the || operator and the to_char function in the sql reference manual, and please try to do so before asking questions of such a basic nature, or you will bore the group to sleep and get ignored very soon.

Regards,

Sybrand Bakker, Oracle DBA

"Scott" <me_at_yahoo.com> wrote in message
news:3ac4f3f0.24256388_at_news.mn.uswest.net...
> I am trying to combine 3 fields in a Oracle 7 view. ITEMNO is text,
> PROD_DATE is a date and SHIFT is a number. In access I would do
> somethine like below:
>
> HIST_ILLUM_PART.ITEMNO+Str(PDAYPROD.PROD_DATE)+Str(PDAYPROD.SHIFT)+AS
> Key
>
> It would return something like:
>
> ZYZ 03/30/01 2
>
> How do I accomplish this in Oracle?
>
> Thank You in Advance!!!
> Scott
>
Received on Fri Mar 30 2001 - 16:20:02 CST