>If time is 11:15 (s_HH = 9 and s_MM = 15), I get "200712121115"
>If time is 9:15 (s_HH = 9 and s_MM = 15), I get "20071212915"
>
>What I want when the time is 9:15 is "200712120915"
>
>If I add PADL to it like this:
>
>

>	PADR(DTOS(s_Date) + PADL(ALLTRIM(STR(Schedule.s_HH * 100)), 2, '0') + ;
>		PADL(ALLTRIM(STR(Schedule.s_MM)), 2, '0'), 30, ' ')    AS Temp ;
>

>
>The result looks like this "200712129015"
>
>

>SELECT ;
>	PADR(DTOS(s_Date) + ALLTRIM(STR(Schedule.s_HH * 100 + Schedule.s_MM)), 30, ' ') AS Temp ;
>	FROM ( 'Schedule' ) ;
>	WHERE Schedule.SchedID == m.SchedID ;
>	INTO CURSOR Temp
>

>
>Any help appreciated...

select ttoc(dtot(s_Date) + s_HH * 3600 + s_MM * 60,1) as Temp ;
 FROM ( 'Schedule' ) ;
 WHERE SchedID == m.SchedID ;
 INTO CURSOR Temp

Cetin