How do I quickly evaluate a text string in SQL?

No, I still haven’t forgotten I promised to get an example of a text string analysis that applies to SQL Server and PostgreSQL

Happy SQL-ing!