What are the challenges you face when working across database platforms? Take the survey

Bug in SQL Compare with built-in function concat_ws

I created a computed column on a table with function concat_ws.
SQL Server Management Studio generates this code:
[FullName]  AS (concat_ws(' ',[CallName],[MiddleName],[LastName])),
SQL Compare generates this code:
[FullName] AS ([concat_ws](' ',[CallName],[MiddleName],[LastName]))
The brackets around concat_ws cause a syntax error.


  • Options
    Thanks for reporting this issue!

    We have reproduced it and logged as SC-10625. We'll keep here posted with any further update.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    Hi @HugoDeVreugd,

    Apologies for the late reply here, the issue in the bug tracking system wasn't updated until just now.

    This has been released (for a little while now, since 13.7.21) so if you have not already, please update to the a version later than this (the latest is currently 14.0.6).

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.