Archives of the TeradataForum

Message Posted: Tue, 28 Sep 2004 @ 14:44:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You may want to try some thing like the simple example below:

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     select 27/(28 (decimal(16,4))) * 100;

     select 27/(28 (decimal(16,4))) * 100;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

            ((27/28)*100)
     --------------------
                  96.4300

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     select 27/(28 (decimal(16,4))) * 100 (decimal (16,2));

     select 27/(28 (decimal(16,4))) * 100 (decimal (16,2));

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

          ((27/28)*100)
     ------------------
                  96.43

	<Prev	Next>		<<First	<Prev	Next>	Last>>