ok

thanks for this Chris. I will try this at work tomoro and let you know how it goes. Much appreciated

thx

ok

This mean instead of getting 10 rows for 1 description column. I think we can use Max function to do this.

cool..try it later.

ok

will try

its a space

I figured out the delimiter thanks

!

Is there a way around it.

cool mate! thank you very much for your help.

CREATE FUNCTION Spitter

--===== Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

--===== "Inline" CTE Driven "Tally Table" produces values...

will send it tomoro