If a column contains a non-numeric character, do you want to treat it is zero? If not, what?

Have you investigated TRY_CAST()?

Remember that the numeric datatype has both a size and...

You need to install SSDT and then add the 'SQL Server Integration Projects' extension.

This looks like a duplicate of https://www.sqlservercentral.com/forums/topic/validate-result

Multiple calls to sqlpackage.exe, with as many different source/target...

If you want a coded solution, please provide DDL, INSERT statements, desired results etc. You know the drill.

I work on sql server 2019 i have issue i can't get percentage of two string from table

so i will compare between two string columns (PartText,MaskText) and i will...

One of the arguments for the SQLPackage command line (link) when Publishing a DB is TargetDatabaseName. Using this, it's quite straightforward to deploy the same DACPAC to multiple databases.

The enable_ordinal argument for STRING_SPLIT is not implemented in 2019.

Here is one way. It assumes that none of the partner_name columns are NULL – some JOIN tweaking may be required if they are.

DROP TABLE IF EXISTS...

Jonathan, I'm going to try your suggestion. I don't think it will work because it should be splited after ' - ' always and show me everything after that...

Using Jonathan's test data, here is the STUFF() version.

WITH cte
AS (SELECT *
    FROM
    (
       ...

Which tools and what sort of data?

Thanks, Jeff, I should have checked that!

You also need to install SSDT for VS 2017 (standalone installer).

Well spotted!