# 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

# A Function Gotcha with the Use of an Asterisk

This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)

3.9 (112)

2009-09-11 (first published: )

18,155 reads

# Converting Hexadecimal String Values to Alpha (ASCII) Strings

In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.

3 (1)

2008-04-25 (first published: )

11,362 reads

# Finding Gaps in a Sequential Number Sequence

Do you use identity values? Do missing values ever cause problems? Maybe you need to look for missing invoices? Stephen Lasham brings us a technique for finding those missing values in a sequence.

5 (4)

2006-04-03

13,621 reads

# Reporting a menu structure using a recursive UDF

Selecting a menu structure from a series of tables is pretty easy. If you bound the number of levels in the menu. However if you have potentially variable numbers of levels. Stephen Lasham brings us a new piece on using recursion to select the data.

5 (2)

2005-10-11

8,559 reads

# Extracting a String Within Delimeters - Part 2

T-SQL can be a complex language to work within and code solutions with. Author Stephen Lasham brings us a twist on his last solution of extracting a string from within another string. Read about his method of working with strings in T-SQL.

2004-09-13

7,844 reads

# 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

16,040 reads

## Blogs

### The End of PASS

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

### Platforms for Events

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

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

Read the latest Blogs

## Forums

### "Home PC" SQL instance

By ifthir

This may be a bit non-typical, but I am currently running SQL 2019 Developer...

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...

Visit the forum

## Question of the Day

### Checkout One File

See possible answers