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

459 reads

Blogs

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Read the latest Blogs

Forums

delete

By sulman.sqldba

    delete

Interview question about CPU

By Lord Slaagh

Hello SSC friends, I am a SQL Developer who is learning how to be...

Who is my customer?

By Kathi Kellenberger

Comments posted to this topic are about the item Who is my customer?

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers