Re: Another week, another SQL request...

[MacWheel99@xxxxxxx]

There is probably stuff in various files that need to be converted from the
old currencies to the equivalent value in the Euro ... think exchange rates.

An excellent source of FAQ on the computer implications of the Euro can be
found in the back issues of Praxis newsletter from http://www.sysmod.com

> On 1st January most national currencies in Europe will disappear to be
>  replaced with the Euro, and so we need to SQL our customer files...
>  Is it possible to do an SQL along the lines of;
>  UPDATE CUSTOMER FILE SET CURRENCY TO 'EUR' WHERE CURRENCY LIST 'FRF' 'IEP'
>  'DEM'....
>  you get the idea.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)