Can anyone point me in the right direction to create from the advanced SQL list of functions:
...a substring of Substr(MKTG_PROMO_CELL_KEY) from character 13 to 6 as "source_id" (field)?
So the function formula is "Substring (<String>, <Offset>, <Length>)", how can I select from the above field ("MKTG_PROMO_CELL_KEY") the characters 13 to 6 within that field (to create a new field ,"source_id")?
Finally, can anyone point me to a good online resource that teaches or lists all of these SQL functions. They're are a lot of SQL sites that lists SQL functions, but anyone know a good site that lists all of them found in Adobe Campaign?