DTOS function is uniform and doesn't depend on user's settings...
BTW, I tried your suggestion and it worked buitifly (I used DTOS() though). So, now instead of 2 SQLs I have one. I just didn't realize, that I can group by ccode, town,... (I considered them as a whole).
>I used transform() because I would not have to worry about date or datetime setting of the field. Of course transform() works best when:
>
>set century on
>SET DATE TO YMD
>SET HOURS TO 24
If it's not broken, fix it until it is.
My Blog