Problem with SQL Select

I am having an issue with a select statement as follows:
When I run the query a field is being created that is too small to hold the
data. I have tested and the following is an example go the select
statement.

SELECT glacnt_a AS gl_account,;
IIF(credit,0.00,glamnt) AS debit,;
IIF(credit,glamnt,0.00) AS credit,;
(fybgbal + ytddr + ptdcr - ytdcr - ptddr) AS balance,;
FROM &sgcpjdbf.\&rept1;
ORDER BY view_order;
INTO TABLE &sgcpjdbf.\&moutput
the fields debit & credit depending on the first record encountered is (N
8.0) or (N 4.2).

Is there any way i can define the size in the select statement?

Thanks for any help
Kevin


.