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.

Pipe characters

2 posts in General Discussion Last posting was on 2005-08-19 20:14:23.0Z
MarkHolmes Posted on 2005-08-19 19:51:58.0Z
From: "MarkHolmes" <mark.holmes@pni.com>
Newsgroups: ianywhere.public.general
Subject: Pipe characters
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: n166h120.pni.com
X-Original-NNTP-Posting-Host: n166h120.pni.com
Message-ID: <4306385e$1@forums-1-dub>
Date: 19 Aug 2005 12:51:58 -0700
X-Trace: forums-1-dub 1124481118 204.155.166.120 (19 Aug 2005 12:51:58 -0700)
X-Original-Trace: 19 Aug 2005 12:51:58 -0700, n166h120.pni.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4705
Article PK: 8499

Sorry, but I'm new to Sybase.
In trying to port a large Sybase db to MS Sql Server I comming across
several differences between the two dbs. Most I can figure a work arround
but the following code snippet stumps me:

update draw
set trip = 'T' || loc_nm
from ...

What are the pipe ( || ) characters used for?

Thanks in advance

Mark


Joshua Savill Posted on 2005-08-19 20:14:23.0Z
From: "Joshua Savill" <jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4306385e$1@forums-1-dub>
Subject: Re: Pipe characters
Lines: 29
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: jsavill-pc.sybase.com
Message-ID: <43063d9a$1@forums-2-dub>
X-Original-Trace: 19 Aug 2005 13:14:18 -0700, jsavill-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Aug 2005 13:14:20 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Aug 2005 13:14:23 -0700
X-Trace: forums-1-dub 1124482463 10.22.108.75 (19 Aug 2005 13:14:23 -0700)
X-Original-Trace: 19 Aug 2005 13:14:23 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4706
Article PK: 8498

Using Watcom SQL syntax, the pipe (||) characters can be used for appending
strings.

Are you using SQL Anywhere Server? If so, what version and build? Why are
you porting to MS SQL Server?

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"MarkHolmes" <mark.holmes@pni.com> wrote in message
news:4306385e$1@forums-1-dub...
> Sorry, but I'm new to Sybase.
> In trying to port a large Sybase db to MS Sql Server I comming across
> several differences between the two dbs. Most I can figure a work arround
> but the following code snippet stumps me:
>
> update draw
> set trip = 'T' || loc_nm
> from ...
>
> What are the pipe ( || ) characters used for?
>
> Thanks in advance
>
> Mark
>