I am trying to add multiple values to a multiple metadata column via SQL using a third party migration tool (Layer 2), but it only works when I add one value as explained below.

I have written some testing code like this in SQL

Select …

(Where Qualifications is the termset and BA and BSc are the terms)

enter image description here

And it works with just the one value with the SQL shown above.

enter image description here

However, I want this

enter image description here

To try to do this, I have amended the SQL like so

,'Qualifications;BA; Qualifications;Bsc '

But sharepoint does not attempt the format and wont add any values

The error I get back from the software is

enter image description here

Does anyone know what the SQL should be to make this work, if possible?


1 Answer 1


Add a pipe e.g. '|' to the list


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.