Canadian Postal Code validator
This is a slight improvement on the script posted the other day. Uses PATINDEX for pattern match, and checks for forbidden characters D, F, I, O, Q, U.
2007-08-14 (first published: 2007-01-15)
472 reads
Blogs
SQL Server on Linux Storage Secrets on Microsoft Channel 9
By kleegeek
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...
Daily Coping 29 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Server vs Instance. A rant.
It’s a SQL Server Instance not a SQL Server. The product is SQL Server....
Forums
SQL Server Agent producing unreproducible error
I've built a Powershell script, which I want to run through SQL Server Agent....
Replace hexidecimal value wih '§' or blank in a TEXT field
I have a DB with a field defined as: dag_text text allow nulls I...
Monitor data and update it conditionally
Hi, Is there a way for monitoring data in a table and update it...
Ask SSC