TRANSLATE maps each input character once, which matters when replacement characters also appear in the search list. Nested REPLACE calls can process earlier replacements again. I compare both results before choosing a cleanup expression.
Showing Comma-Separated Role Members for Every Database Role
Comma-separated role members make direct assignments easier to review. The queries retain empty roles and label public membership as implicit. Keep the underlying rows because nested roles and directory groups need a separate effective-access review.
Splitting Text on Several Delimiters With REGEXP_SPLIT_TO_TABLE
REGEXP_SPLIT_TO_TABLE handles several separators in SQL Server 2025. These examples keep source keys and ordinals while separating trimming from empty-token handling. A small edge-case set also shows where a regular expression is not a CSV parser.
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case
My UDF udf_TitleCase converts any string to Title Case, also called Proper Case. The post has a sample call, its output and the full T-SQL code of the function.
SQRT: Keep Fractional Roots in the Result
SQRT produces an approximate square root. These read-only examples preserve fractional roots, state the display precision and distinguish a missing input from zero.