This content has been marked as final. Show 5 replies
I'm loading a Table and based on the informations I have in the field 'comment' I would like to build a new field Status.
if(comment like '*Test*', 'Test',
if(comment like '*Blocked*', 'Blocked',
if(comment NOT LIKE '*check*' and NOT LIKE '*analyse*', 'To be checked',
if(comment like ......)))) AS Status
Thanks for your help