[personal kdb+] Concat column in table

[Adrian]

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

--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To post to this group, send email to personal...@googlegroups.com.
To unsubscribe from this group, send email to personal-kdbpl...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/personal-kdbplus?hl=en.

[Manish Patel]

Assuming strings in the cols,

select fulln:(firstname,'lastname) from table


Sent using BlackBerry® from Orange

[Jyoti Ranjan Sahoo]

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

 

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