On 9/12/06, Allan Kamau <kamauallan(at)yahoo(dot)com> wrote:
>
> Hi all,
> This is a plain simple sql question appologies for
> posting it here.
>
> Am looking for a way of combining values from several
> fields(and introducting value separators).
>
> select field2+"_"+field1 from tableA;
>
> I've tried
> select field2||'_'||field1 from tableA;
> I get "1" as the result(which is not what I want).
What does tableA look like (DDL and the data)?
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================