Hi Grant,

Thanks for the reply. I had tried using the profiler myself - with no result - I should have said that, sorry.

I think you're right. I'm going...

Perhaps you could 'invent' some parking wheels that are fixed sideways on the underside of the car. They could lower like a plane's undercarriage to raise the car up,...

Oh where are my manners today?

Yes, for teenagers (and my son is a goth too) they are really quite sweet. Not them image society portrays of teenagers or goths is it.

I suppose an even...

Being a girlie it really is the thought that counts for me.;)

Flowers and choccies are nice to receive of course, but they are too easy and show no thought. ...

CharIndex returns a zero if the search string is not there. I'd check your data to see if they all have a comma in.

--Not very elegant but I hope this helps cut, copy the whole lot into

-- query analyzer to test

--I made a test1 table to hold a fullname

create table test1

(fullname varchar(80)...