Azure Datafactory to update a sql table column with Character Plus Autoincrement

Hi All,

I got a requirement to update a column in a SQL table using the combination of Character + Auto number sequence via ADF.

For e.g : abc231

abc is the character

231 is the next sequence and passed via ADF parameter

Number Sequence starting number  will be an input parameter in ADF.

Any help will be appreciated.

Thanks

Sandz