>I don't think I can use ttod() since sql doesn't recognize it as a function, but I apprecite the response.
Depending on your requirements, you can get the complete datetime value first, into a cursor, and then do a VFP - SELECT in which you use ttod().
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)