Hi there

I work in a SQL 2000 developer edition. when I run the provided script, it runs successfully returning rows 1 through 6.

I did not dound any conversion error.

Ashok

I've successfully tried this query

Select Replace('30:06:2008',':','.')