As the idiot who was rushing and didn't see the extra pages of replies I offer my apologies 🙂

In my instance there are c2000 records with forenames but no Title...

I agree there is an intermittent need for this and have just updated to SQL 2005 and hit this gotcha.

My query was of the form

select stuff from table1 t1

...