Cheers Gail that's great, thanks.

I'll read through that article. I'm coming from an Access background so its a whole new ball game but I'm loving it!

Joe

Mr Burstein you are a genius, thank you so much that is exactly what I was looking for!

I've turned that into a stored procedure which works with my table and...

Thank you Jacob and Lynn, top people!!.

It's all great, it works and gives the desired results.

Thank you so much for your help it's saved me a big headache!! 🙂

Hi Jacob and Lynn,

Thank you so much for your quick replies and the brilliant solutions.

I've placed your scripts into a stored procedure and they work just great.

USE...

I did come across this one on the stackoverflow website, I can't vouch for it's efficiency but it works just fine.

CREATE FUNCTION [dbo].[ufn_CSVToTable] ( @StringInput VARCHAR(8000), @Delimiter nvarchar(1))

RETURNS @OutputTable TABLE...

Michael, thank you so much for your patience and quick reply, greatly appreciated. I've now got it working with your help!!

I'm an Access developer looking to upsize to SQL Server....

Hi Michael, thank you for for the quick reply, I've had a look at the sample and created the function, but I can't see how to apply it to my...

Hi Cadavre,

I don't know how to thank you enough for such a comprehensive answer, this is exactly what I was looking for.

I'm picking through it bit by bit to...