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

454 reads

Blogs

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Why Aren’t You Automating Database Deployments?

By

Building out processes and mechanisms for automated code deployments and testing can be quite...

Daily Coping 23 Nov 2020

By

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

Read the latest Blogs

Forums

Query performance with ROW_NUMBER function

By vijayd

Hello All, Could any of you please let me know why the row_number paging...

multisubnet configuration

By abdalah.mehdoini

Good morning all , I am in an alwayson multisubnet configuration, the listen and...

Simple Recovery Model - Active VLFs cannot be truncated

By jdlayton83

Hi everyone, I am facing a strange situation. I've got 99% of VLFs active...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The ADF Case

See possible answers