Ok, but the 3 numbers are in 3 different columns. So how to concatenate the
3 numbers to one number in one column???
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3c7b96c1$0$8510$ed9e5944_at_reading.news.pipex.net...
> 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:47:16 CST
