That worked a treat, I've been trying to search for that one for hours.

Thank you for your help

Dave

Its simple enough to find out which ones are in the format yyyy/mm/dd as they appear in the results as a '1' when using the following sql statement.

SELECT     CHARINDEX('2005', dateOnlyEnd)...

I'll have a look into that thanks.

Will let you all know how I got on

wow it worked

Thanks a lot, I totally appreciate that

nice one

I have to actually head off now, but thanks for the help and I'll check these posts again tomorrow.

Thanks for the help

Dave

The table name is correct, but what is the owner/username?

Hi thanks for getting back to me. The code I'm using is....

Update dbo.CallLogRevenuesTEST set dateOnlyEnd = SUBSTRING( dateOnlyEnd, 9, 2) + '/' + SUBSTRING( dateOnlyEnd, 6, 2) + '/' +...

I probably should have realised that was SELECT

But that just selects the rows from the table, how would this be made into an...

I'm totally new to this SQL Server stuff, I'm having difficulty understanding the ELECT statement.

What do the numbers 9, 2   and 6,2 mean?

I could easily change it to a date, but is it possible to change the format using SQL coding

Thanks