>problem in this code, for dayn(date). How i can use dtoc for date converting in character. thanks
>

......  ALLTRIM(CAST("Daily attenddance report=>" +DTOC(dayn)+ "Total:"+ALLTRIM(STR(total))+"/A:"+ ALLTRIM(str(A))+"/H:"+ALLTRIM(str(H))+"/L:"+ALLTRIM(STR(L))+"/P:"+ALLTRIM(STR(P))+"/tage:" as CHAR(254))) AS ghttt
>

Is this expression part of SQL command?

If not, I would try the expression separately before casting.