Thanks vijayarani87.s

This simple solution worked perfectly - I just had to include 'set dateformat dmy' before the 'convert'.

Much appreciated,

Peter

Problem solved - Thanks for the advice.

The substring solution worked, but a string length of 8000 would only return 4200, so I ended up using the following:-

settm.cntct_notes1 = substring(notes.note, 1,...

Thanks heaps for the advice John.

The column headers were gone, but still had all the embedded blanks. I had included a | character to be used as a delimiter...

Even though thanks was given earlier, before the additional interactions, I would like to reiterate:-

Thanks heaps guys for your solutions, explanations, advice and fun.

This won't be the last time I...

OK Jeff - Why is it necessary?

(Hope I got the question right)

I have another question RBarry.

What do the two extra 'a' characters signify? I know that they make the script do what it should, which is fantastic, but I can't...

Thanks RBarry, this version works well.

I've had to revise my thinking. It's good to have different options from which to choose.

This has been a rewarding first time experience of...

Thanks for your suggestions guys.

I was most impressed with RBarry's solution, but unfortunately nested selects did not work on our SQL2000 site. I got an 'incorrect syntax' error.

I've decided...