>I need to create a number field, (length-7, decimal,2) in a query, how do i do that. Rate is the field that i am trying to create.
>
>SELECT pdsub.*, SPACE(1) AS ratecd, SPACE(7)AS rate;
> FROM pdsub.dbf;
> INTO TABLE wkpaid.dbf
>
>
>Thank you in advance for your help.
assuming that ratecd should be c(1)
Select pdsub.*, Space(1) as ratecd, 0000.00 as rate ;
from pdsub ;
into table wkpaid
note: the decimal point is significant in the length
Insanity: Doing the same thing over and over and expecting different results.