I need to update the display_name column in all rows of my form table to replace any occurrences of ‘NT NT’ at the beginning of the display name with a single ‘NT’. How do I do that given I need it to search for ‘NT NT%’ instead of the exact string ‘NT NT’?
Tried trim and replace functions, but running into issues with the variable %