Hi,

What is the equivalent for CONCAT() syntax in sybase ?

TIA,
Nicky.

Nicolas Mainczyk wrote:
The plus sign (+), eg:

'This is the equival'+'ent of concatenation.'

--
Mark A. Parsons

Iron Horse, Inc.
iron_horse (AT) NOSPAM (DOT) compuserve.com

"Nicolas Mainczyk" <nmainczyk (AT) hotmail (DOT) com> wrote


We really can't answer that unless you describe what it
is that this "CONCAT()" syntax does in the first place.

If you are looking to concatenate two char or varchar
values, you can use the "+" operator:

select "abc" + "def"
go

-bret

I would like to concatenate an INT + VARCHAR.
When I use '+' he tells me to use convert function because he can't convert
CHAR to INT implicitely..
What is the syntax then ?

TIA
Nicky.


"Bret Halford" <bret (AT) sybase (DOT) com> a écrit dans le message news:
34c88f2b.0407061358.5ee149b7 (AT) po...OT) google.com...

"Nicolas Mainczyk" <nmainczyk (AT) hotmail (DOT) com> wrote

Just use the convert function as the message says:

convert(varchar, your_int_column)


HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of various Sybase books. New book (coming soon): "The
Complete Sybase Replication Server Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

On Wed, 07 Jul 2004 10:31:41 +0200, Nicolas Mainczyk wrote:

One way would be
select convert(char, intvalue) + charvalue from ...

Michael


--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html