Stephen Lasham

Born in England in 1966 (I'm now 38). I moved to New Zealand at 18 and qualified with a New Zealand Certificate in Data Processing (NZCDP). I worked for Nestle New Zealand for three years, then as a consultant for several software houses, and for the last ten years I've worked in local government. For 18 of these years I worked with IBM System/38 and AS/400's programming in RPG/400. For the last year I have been writing SQL and using Crystal Reports, after the council changed its core software to Pathway by Geac. I am married with three children.
  • Interests: Photography

SQLServerCentral Article

Extracting a String From Between Two Delimiting Characters

String manipulation in SQL Server or T-SQL can be a challenage. There are multiple ways to accomplish every task and often learning a new one may spark some creativity in yourself or teach you a better way to accomplish an old task. New Author Stephen Lasham brings us his technique for extracting a string that is delimited from within a larger string. Something I'm sure we'll all have use for in the future.

3.67 (3)

You rated this post out of 5. Change rating

2004-06-14

20,419 reads

Blogs

Microsoft Announcement: Microsoft Fabric

By

Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...

Introduction to SQL Server Query Store

By

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Flyway with Multiple Folders

By

A customer asked about how they could organize their migration scripts in different ways...

Read the latest Blogs

Forums

You have an error in your SQL syntax; check the manual that corresponds

By yrstruly

I am having great trouble creating a data pipeline using MariaDB connector 3 with...

Availability Group database went into 'Restoring' state

By Arsh

Dear Friends, Please advise why would one of my Availability Group databases go into...

Access db

By sqlguru

Access db wanting to move  sql server, how much control does business have over...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers