Certainly gives me somewhere to start. Many thanks Crispin.

I've not seen anything to do this, but I guess you could write a function that would take a string parameter and do a replace on all the charactes you...

Please also ignore my awful spelling for the topic of this post!!

PD and Michael,

Many thanks for the response. Lots of things for me to consider. I would much rather go down the SSIS route as I'm a big fan of DTS...

I couldn't agree more. Learning from your mistakes makes you stronger and increases knowledge. I don't think it is a problem copying code from forums etc so long as you...

The company I now work for has been absolutely excellent for training, though this is in stark comparison my previous employer. Living in the UK and near to London means...

Hi Paul / SM,

Thanks for this as well, just what I needed.

Regds,

EP

Sorry, missed above post. Also have a look at Books On Line with regards to the CONVERT function as this contains a good table for date conversion.

This should do the job, there were a couple of missing apostrophes and and no length had been declare for the varchar.

SET AUTH_DATE = convert(datetime, (convert(varchar(8), '04/06/05', 103)))

Hope it works.

I agree, DTS sounds like the way to go.

With regards to learning about SP's, Ken Hendersons Guru's Guide to T-SQL is excellent and covers so much about T-SQL. There...

Prasad / Steve,

Many thanks, I have now read up on charindex and patindex. Does exactly what I need.

Ed

Many thanks Steve. Have put in place and will be running tonight.