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

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3

By

This is the third post in a series about modern Data Lake Architecture where...

Event Notifications Example

By

Event notifications are kinda like a trigger in the sense that they respond to...

Did you know we have another SQL Server book coming out?

By

SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Read the latest Blogs

Forums

Can't Get Attunity Oracle Connector to Work with SQL Server 2017 / Oracle 12c

By brad.mccollum

I've tried many times to install the various versions of the Attunity Data Connector...

Using Java script to import word and pdf into SQL server

By pcq0125

I am looking for example or use case codes  in using Java script to...

Using sftp in Visual Studio for SSIS packages

By Isabelle2378

Hi, I've inherited the maintenance of SSIS packages that were created by our former...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers