Hi Don,

I agree with Andy, that SQL Select doesn't change format of the columnms pulled directly from a table. Something else is affecting result. What if you run following code.

SELECT Transact 
LIST STRU
SELECT ;
  Account  ;
  FROM Transact ;
  INTO CURSOR test NOFILTER
LIST STRU
BROWSE NOWAIT

Do you still see truncation?
Do you've SP1 installed?
BTW, you can use < pre > and < /pre > tags (w/o spaces) to preserve code formatting and make it more readable.

>Sorry about the confusion, I had copied the data set for testing instead of using the original. In the query I had renamed some of the elements. The naming is corrected below.
>
>I have run this over a dozen times checking all elements as described in the primary msg.
>I have confirmed that the query is selecting from the designated table each time, but is still truncating the third digit of the decimal value.
>
>A query ALWAYS brings in the Account column as N(10,2)
>The specified column is NOT undergoing any manipulations.
>Some of the records have values in the decimals at position 3.
>
>Source data looks like: 2300.001
>Result data looks like: 2300.00
>
>Query:

>	SELECT ;
>		Client, ;
>		Account  AS AcctNumb, ;
>		SUM( Amount ) AS SubTotl ;
>	FROM Transact ;
>	WHERE Client = 1 ;
>	  AND BETWEEN( TranDate, {01/01/80}, DATE() ) ;
>	  AND TranCred > 0 ;
>	GROUP BY Client, AcctNumb ;
>	ORDER BY AcctNumb