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

23,131 reads

Blogs

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

SQL Clone at Scale with Striped Backups

By

I had a customer recently reach out to ask if SQL Clone would work...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Managing unused indexes

By JasonO

While doing some housekeeping activity on several old but large production databases, I come...

Cloud Performance Considerations

By MichaelT

How important to SQL Server is the speed of the SSD and network latency?...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers