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)

2004-06-14

18,654 reads

Blogs

Daily Coping 20 May 2020

By

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

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

Read the latest Blogs

Forums

min and max startdate

By Shree23

Hi Expert, I wanted to calculate max date for prodstatus =5 - min date...

Azure DE Interview scenario/case questions

By kinporsch

Hello guys, I am preparing for Azure DE positions with Data Factory, Databricks, Synapse....

MS SQL Server 2012 question regarding SSIS

By ageilmelo

OK so I have a customer with a hosted website with eCommerce options. Essentially...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers