Thanks for your reply -

The problem is that there is a "Custom Database" setup which people have used Text/Char fields to store numeric in - what I am trying to achieve is;

When a record is added, a trigger will fire and check that there is a numeric entered into this field - it is exchange rate, so a default value of 1 ( ONE ) needs to be there - users are entering text and/or leaving blank which is causing problems.

The trigger that was created is already working and in production.

I agree with the "X" - but this was just a catch all at the end of the script.

Regards