I saw that. Thanks John!
>Kevin, cool link- though I see that MS SQL2008 delivers a proper time field. ;-)
>
>Tracy, note use of 1900-01-01 as the date in the sample. If you can do this every time, then you can do searches and calculations using the time portion only. Use standard VFP TIME() format with the same parameterized SQL. If you do this, you preserve the ability to use datediff() and similar features in future. Before you decide, make sure you know whether and how you're going to handle blank/unknown time values. ;-)
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"