TAman (7/29/2009)
Okay, I understand how your code is working now. But your sample data is not like my sample data. My data doesn't always have 6 characters. It is sometimes 5 characters and 6 characters.
I know your data does not always have 6 characters - neither does mine if you look at what is actually in the table. I inserted the data that way to show what happens for times with leading zeros when stored using bigint.
You will have times in your data with only a single digit - for times that are 00:00:00 through 00:00:09. Those times will be stored in the table as 0 through 9.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs