Ampscript in marketing cloud - If value LIKE

Question

Similar to SQL, I was wondering if your able to add ampscript that say if a value is like a wildcard. For example, %%[IF Value LIKE "%1234" THEN]%%

Answer 1

You can use the indexOf function:

%%[ if indexof(AttributeValue("value"),"1234") > 0 then ]%%

If it needs to be more specific you can use a combination of the length and subString functions.