the oracle concatenation operator is ||
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"J_at_n Burgers" <j.burgers_at_hccnet.nl> wrote in message
news:a5g29j$q3v$1_at_news.hccnet.nl...
> My SQL query results in a id which consists of 3 different numbers. I want
> to concatinate these 3 numbers to one id number without spaces in between,
> but how???
> Anyone who can help??
> Jan Burgers
>
>
Received on Tue Feb 26 2002 - 08:07:54 CST
