
Assuming stringn is required, the following result was found.
offset]) PATINDEX(%needle%, haystack) CHARINDEX(needle, haystack [, offset]) String Concatenation CONCAT(string1,string2[,stringN]) string1 + string2 SS v2012+: CONCAT(string1, string2 [, stringN ]) String Substring SUBSTRING( string,start,length )...

 bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
 0xb038962F3809b425D661EF5D22294Cf45E02FebF
0xb038962F3809b425D661EF5D22294Cf45E02FebF