>What about the currency type... does this take up less space ?

Sure - only 8 bytes. But I've never used that and don't know what the disadvantages might be

>
>
>
>>>Hi.
>>>I've hit the 2 gig lim on a file in an app
>>>It would be a huge job to start splitting up the file , or going to SQL SERVER so i'm trying to identify other options,
>>>There arent that many characyer felds that I can reduce, but there are a few numeric fields I could optimise.
>>>I have these now set to N 17 2 and would need to allow for 999,999,999.99
>>>Whats the Least otimum numeric data type for this ??
>>>Also, if there are any other suggestions ?
>>>
>>>Regards,
>>>
>>>Gerard
>>
>>Well I make that N 12 2 should do - no?
>>If you don't need the dec places then integer would just do it.
>>
>>See "Data and Filed Types" in Help for capacities.
>>
>>HTH
>>
>>Terry