The result of TRNSFORM() is affected by date/datetime setting. It's better to use DTOC(...,1)/TTOC(...,1).

>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