LOL. I am not responsible for the design of this datamodel. I just inherited the headache of it.

Thanks again for your help.

WOW! Remind me to never use the float datatype for storing datetime data :). This is greatness let me try it out.

Ok this works however it is still a float in the table I am querying therfore can't be converted to a varchar easily, at least not for me anyway.

I was thinking that but did not want to take any performance hit by converting it to a varchar. This seems like the only way to do this. Your code...

Yes they are all that way yyyymmddhhmmss