>>In my Employee table sample, the Birth_date field is of type Date. I think that exist something around it.
>
>No Erick,
>It happens with datetime fields consistently (it was a quick sample to send here. In original code I hit this the field was really a datetime field).
>
>SELECT emp_id, DTOT(birth_date)+3600 as bdate ;
> FROM (_samples+'data\employee') ;
> INTO CURSOR crsDummy nofilter
>SELECT emp_id,EVL('dummy',TTOC(bdate)) as bdate FROM crsDummy
>
Cetin
Why would you expect 'dummy' to be empty to start with? Should it be
evl(ttoc(bDate),'dummy') instead?
If it's not broken, fix it until it is.
My Blog