>Never search like this:
>
>
select * from myTable where myDatetime = m.ltDatetime
>
>But like this:
>
>
select * from myTable where ttoc(myDatetime,1) == ttoc(m.ltDatetime,1)
>
>or a similar expression.
>Cetin
When > < Between() is it also better to use ttoc()? Like ttoc(myDatetime,1) >= ttoc(m.ltDatetime,1)
Kamil
A moment of silence is our cosmic reset button.