Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Putting columns together

3 posts in PB Infomaker Report Writer Last posting was on 1998-04-21 16:16:20.0Z
Jim Tobin Posted on 1998-04-02 21:47:06.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 02 Apr 1998 16:47:06 -0500
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
Subject: Putting columns together
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 9
Message-ID: <348_3524075A.DAD9774@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7169
Article PK: 243198

Hi!

I need to put the last name and first name together like this:

smith, jim
and
14 main st., sometown, ct.

It seems I need to do this first:
RightTrim(Last_Name)
but, what do I do next. I assume this is all done within a computed
field?

Thanks, Jim


Larry Molter Posted on 1998-04-21 16:16:20.0Z
Newsgroups: sybase.public.infomaker.general
From: lmolter1@tampabay.rr.com (Larry Molter)
Subject: Re: Putting columns together
Date: Tue, 21 Apr 1998 16:16:20 GMT
Organization: PowerCerv
X-Newsreader: Forte Free Agent 1.11/32.235
Lines: 22
Message-ID: <348_353cc55f.14735904@forums.powersoft.com>
References: <348_3524075A.DAD9774@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7136
Article PK: 243166

On Thu, 02 Apr 1998 16:47:06 -0500, Jim Tobin
<jimtobin@compuserve.com> wrote:

Like Terry said, I would use a computed column, i.e., one that is
created on the server, in contrast to a computed field, which is
client-side. The caviat to Terry's answer is that single quotes
should be used around string literals. Otherwise, the server MAY
interpret what's inside the quotes as a column name.

lastname + ', ' + firstname.

The slide option is ok, but a computed column or computed field is a
better choice.

>Hi!
>
>I need to put the last name and first name together like this:
>
> smith, jim
>and
> 14 main st., sometown, ct.
>
>It seems I need to do this first:
> RightTrim(Last_Name)
>but, what do I do next. I assume this is all done within a computed
>field?
>
>Thanks, Jim
>


Terry Dykstra [TeamPS] Posted on 1998-04-03 18:08:00.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Putting columns together
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Fri, 03 Apr 1998 13:08:00 -0500
Lines: 20
Message-ID: <348_01bd5f34$bd4cb160$3301020a@tdykstra>
References: <348_3524075A.DAD9774@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7166
Article PK: 243195

Either create a computed column: trim(last_name) + ", " + trim(first_name)
or you can use the slide left option: between last_name and first_name you
add a text_box with a comma in it. Then for the text box and the
first_name column you set the slide-left property.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Jim Tobin <jimtobin@compuserve.com> wrote in article
<3524075A.DAD9774@compuserve.com>...
> Hi!
>
> I need to put the last name and first name together like this:
>
> smith, jim
> and
> 14 main st., sometown, ct.
>
> It seems I need to do this first:
> RightTrim(Last_Name)
> but, what do I do next. I assume this is all done within a computed
> field?
>
> Thanks, Jim
>
>