geobo@els.liu.se wrote:
: I have a table with money fields and would like to export them to a tab 
: separated file. If I use the usual "copy into" statement the $-signs are 
: included in the file. Any ideas how to create a file with only the digits.

Dear George,

You should set the environment setting 'II_MONEY_FORMAT' to 'L:' (Leading 
money-sign which is in this case blank) BEFORE you export the data in
a file.

Regards,
Herman Smit
+-----------------------------------------------------------------------+
| Herman Smit                    	    E-mail : h.smit@prophecy.nl |
+-----------------------------------------------------------------------+

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William