Now for the functions. This week I am looking at REGEXP_REPLACE in SQL Server 2025 and wowsers. I am starting to wonder why I never learned this stuff for other uses (or implemented it with CLR). This ...

SQL TIP: If any argument in REPLACE() is NULL, the whole function will return NULL This is because SQL treats NULL as “unknown.” Any operation involving NULL generally results in NULL If you don’t ...