Creatin Column

[priyarane]

Hi Experts,

How to create a new column with 2 Fieds like below.

Tab:

Name,

Dept

From

C:Tab\Tab.qvd;

I want the new column needs to add with 2 fields

Like -

RegApproach(New Column)

US

PRA

I tried like below

Tab:

Name,

Dept,

'US' as RegApproach

From

C:Tab\Tab.qvd;

But I can't add PRA field

[#2]

you can use by using space or comma between two value... like

'US, PRA' AS ....

[priyarane]

It will come like

Column_ Name

US, PRA

I want like

Coulum_Name

US

PRA

[#4]

TRY THIS

'Text1'&Chr(10)&'Text2' as new,