[personal kdb+] Concat column in table

Community Support
,
1

Hi all,

I have some question of string concat function. Normally, q use , to
join element up. But how can we apply it to a select statement?

For example: I have a table called name like this:

FirstName LastName

David Chan
Peter Chan
Daivd Lee
Joe Chan

how can I join the two columns in a q select statement?
wholeName

DavidChan
PeterChan
DaivdLee
JoeChan

–
Submitted via Google Groups

2

Assuming strings in the cols,select fulln:(firstname,'lastname) from tableSent using BlackBerry? from Orange-----Original Message-----From: Adrian <adrian.tam28>Date: Tue, 20 Apr 2010 02:58:50 To: Kdb+ Personal DevelopersSubject: [personal kdb+] Concat column in tableHi all,I have some question of string concat function. Normally, q use , tojoin element up. But how can we apply it to a select statement?For example: I have a table called name like this:FirstName LastName--------------------------------David ChanPeter ChanDaivd LeeJoe Chanhow can I join the two columns in a q select statement?wholeName---------------------DavidChanPeterChanDaivdLeeJoeChan–

Submitted via Google Groups</adrian.tam28>

3

Please use this query and let me know abt the result:

 

select wholeName : “” sv/: flip string(FirstName;LastName) from name