Hi Gaby

Whilst everything you say is true, the environment I have to deal with is:

Software vendor creates a product based on SQL, and sells it to client.

Client wants some simple...

Hey Paul, that works a treat! Thanks! I can pop the data into a temp table and join it to the rest of my query to get the answer I...

Thanx for your suggestions!

I'm glad it doesn't appear to be a crime to use undocumented features after all!

BACKGROUND:

I'm working with a 3rd party database on a finance/manufacturing system that I...

Hi Alasdair

Lots of sites on the web offering Excel add-ins that poll ex-rates overnight - perhaps you could use one of these?

Or look at OANDA.com - they advertise "FXP" -...