Parse a fixed length numeric value from a string

Specifically, I needed to parse a zip code (5-digit) from a client comments fields where the number was in different positions such as "Customer 999999999 should be at zip code 99999" and "99999 zipcode" and "should be zip code 99999 phone 9999999999". My stored procedure first filters on a [Comments] field string that contains variations […]

2006-11-08 (first published: )

444 reads

Blogs

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

full text search

By Sailor

Trying to understand why when I search for numerics in full text, contains does...

New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012?

By Andy sql

MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...

SSIS Package/Agent Job Not Failing!!!

By tim.ffitch 25252

I have a package running in SQL 2016 using Project Deployment. One of the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers