Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi their.
i need help in merging a NAME and a SURNAME from different fields. Could i possibly get the steps to doing this?
Hi
Using the '&' Operator to merging the fields.
NAME &''& SURNAME AS FULLNAME
Regards,
Iyyappan
Hi again Iyyapan v
Name &"& Surname as Fullname did merge the two field but renaming it as FULLNAME didnt work. i left an example to help, Thanks.
@3 as MemberNo,
@4 as Surname,
@5 as Initials,
@6 as Title,
@7 as FirstName,
@8 as CashCustomerNo,
Hi
Use like this
TempTable:
Load
@3 as MemberNo,
@4 as Surname,
@5 as Initials,
@6 as Title,
@7 as FirstName,
@8 as CashCustomerNo,
From
DataSource
Table:
Load
FirstName&Surname As FullName,
MemberNo,
Initials,
Title,
FirstName,
CashCustomerNo
Resident TempTable;
you want space from FirstName and Surname use like FirstName &' '& Surname AS FullName
Hope its help
Regards,
Iyyappan