Field concatenation
Try the following:
select OrderNo || Ordersuf as Order
From PUB.xxxx
Jackie
>I would like to concatenate two fields in a select statement into one:
>OrderNo and ordersuf
>
>Select (OrderNo + Ordersuf) As Order From PUB.xxxx
>
>Thanks,
>Eric
