Merging two columns 1

[wdbouk]

Hello ,

I am trying to merge two columns in the following way
(table's name=ISSUE,first column=issuer_cusip, second column=issue_cusip)
UPDATE ISSUE SET issuer_cusip = CONCAT (issuer_cusip,issue_cusip);

but i am receiving the following error message:
undefined function "CONCAT" in expression. Any hint of what went wrong or if possible how to do it?

 

[lespaul]

does this work?: (disclaimer - run as a select first!!

SELECT issuer_cusip & issue_cusip from ISSUE and make sure you get the correct results)

then:

UPDATE ISSUE SET issuer_cusip = issuer_cusip & issue_cusip;

Leslie

 

[BobStubbs]

A couple of extra thoughts ...

If you need a space between the two original data items, as you would (for example) if they were names, write:

UPDATE ISSUE SET issuer_cusip = issuer_cusip & ' ' & issue_cusip;

If this is a 'one off' job, it might be quicker / easier to write an update query, with the update formula written as:

[issuer_cusip] & [issue_cusip]

You can then look at the underlying SQL in SQL view, which may provide other useful ideas!


Bob Stubbs