Hi,

My Server Win2k's regional settings are set to Spanish (Spain-Traditional)
and the currency to Euros.

When setting a field in a table to money, the amount is displayed as pta
with two decimals (ptas = pesetas old monetary system).

In a query, I tried ROUND (money_field, 0) to truncate 12.345,23 to 12.345
but the server responds with 12.345,00 pta. If I change the field type to
real or number, the results are displayed as 12345.00.

Just cannot seem to get it right.

What am I doing wrong? Is there a regional setting hidden within SQL2k?

TIA

Ana

can't delete a row from primary table - is there an SP for this?
Ranking Rows
T-SQL
simple trigger question
UDFs - what resources used?