Link to home
Start Free TrialLog in
Avatar of edgecrusher762
edgecrusher762

asked on

How do I populate a specific column based on other columns in the same table?

I am trying to populate a column with concated values from other columns in the same table.  This 'new column' is blank and needs to be filled like so:

1  |   2  |  3  |  4  | new colum
----------------------------------
a  |  b  |  c  |  d  |       abcd
e  |  f  |  g  |  h  |        efgh

and so on.  Can I construct a query that will fill every row of 'new column' with the values from the other 4 columns?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of edgecrusher762
edgecrusher762

ASKER

Thanks a ton.  Works perfectly.