>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
>
>
SELECT pdsub.*, space(1) AS ratecd, 00000.00 AS rate
actually creates an N(8.2) since the decimal poinmt occupies space in an N field; leave off a leading 0 to make it 7,2