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
- 2,626
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-...
- 28k
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 ...
- 2,626
Only top scored, non community-wiki answers of a minimum length are eligible