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: )

452 reads

Blogs

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 26 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Read the latest Blogs

Forums

schedule a job in CMS

By mtz676

Is it possible to schedule a sql job in CMS ? As of now...

what does it mean for the following SQL Scripts

By 892717952

in a stored procedure, I found two line sql scripts "    if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...

Recovering Databases From a Master Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Recovering Databases From a Master...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers