4
Reply

insert two column information into one column

ajay raju

ajay raju

Mar 30 2010 3:43 AM
7k

hi
i take 3 columns in my sql server table i.e., firstname, lastname,Contactname
i insert firstname and lastname then contactname is (firstname+lastname).
how to write the query.
i tried like
insert into contacts values ('ajay','kalidindi','(firstname+lastname)') but here display contactname is firstname+lastname.
please give a reply. urgent
thanks.

Answers (4)