Hot answers tagged

2 votes

Marketing Cloud - SQL - Merge values from three columns into one

Assuming the fields are never null, it's simply: Concat(PO, ID, Domain) as NewColumn
user avatar
1 vote

Unique Opens no working

A few things: Underscores are wildcards in LIKE conditionals in T-SQL. You'll need to escape those with square brackets. lower() isn't needed as the underlying SQL Server database is case-...
user avatar
1 vote
Accepted

Add leading 0's to a character string

Let's assume the number you want to pad is stored in a column called YourNumber and you want to achieve a length of 3 characters. So for example 7 would be transformed into 007. To make this happen ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible