Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can use by using space or comma between two value... like
'US, PRA' AS ....
It will come like
Column_ Name
US, PRA
I want like
Coulum_Name
US
PRA
TRY THIS
'Text1'&Chr(10)&'Text2' as new,