>>This is not a good way, but can you explain again what you were trying to achieve and what is the table structure, some input data and desired output?
>
>Those who built the database decided to store the date in a Date field (just the date portion) and the time into a Char(8) field. So, this is the problem I had to deal with.

Is the date field a Date field? (or DateTime)?