Worked example - Using regex to refine a SQL script
I was recently asked to copy some data in a SQL Server database but to exclude records which had the words 'To Delete' in their names. This is a simple enough task - throughout the SQL I wrote, I added to all the WHERE clauses this line: AND ISNULL([...
Mar 29, 20232 min read26
