example: in gupta I could write the following sql statement to insert
multible columns from one table into a singe column in another table.
insert into receipttable (id,name) select id,firstname|| ' ' lastname
from mastertbl where id=1
sql server 7.0 -- i get the following error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '|'.
How is this done?