I thought EMPTY(ALLTRIM(mytable.mydatetime)) would work to check for an empty datetime field, but I guess I have to convert it first???
It doesn't seem to work as above.
Thanks for your assistance.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.