Yes indeed I am all set with the brute force method.  Actually more like a stored proc.   While I work on implementing or perhaps reinventing the data rules within standards...

DOD = Department of Defense.   It sets standards just like ISO etc..

I understand that..but DOD requirements dictate this type of storage.

No unfortunatly i have to keep them in one row.   like i described in my query.  I am not sure what you meant by relational diviosn..but i look forwrd to...

Go tit..it's surprising to me how many times while typing Got it...I somehow manage to type Go tit.  Wonder where my mind is...Anyway, yes indeed the datetime column is not...