Steve,

I don't have much planned at present. I've been in fulltime employment since March 1961, and continuously with my current employer since August 1966, so initially, I'm just looking forward...

Thanks Jeff

I overlooked NULLIF, not having used it much in the past

Brendt's solution is elegant, but unfortunately won't work in our case without some amendment. Some of our fields correctly contain NULL, but some are just blank, and these leave blank...

The problem with goodguy's solution is that any blank fields will leave blank lines in the resulting select.

We faced a similar problem and got round it this way

DECLARE @AddressString VARCHAR(250)

SET...

Many thanks to all who replied. Has given me some ideas on the way to proceed.

Bruce

We had exactly that problem. My way round was to create an index field and a "done" field in the table, and use a variable @index. When the...