I am new to Teradata Dev.Could you please help me with the below request.
CASE WHEN Tablename.ID LIKE 'pattern matching' THEN 'CNN'
Sample IDs :1-1NRVGXL,1-229HGKM,1-RMKZWA
So,how to write pattern matching for this.
Thanks in advance.
Just a stab ... but while you give dieter his answer in case it is an involved match, you aren't just asking for how to wildcard, are you?