Check Constraints Error

[John Cassell]

Hi All,

I am using SQL Server Express 2005 Management Studio.

I have just assigned a constraint to my column saying that the value cannot be more than 50,000.00.

When I put 60,000.00 into a field in that column I get an error (as expected) but it is a big messy one.

I would like the user to be presented with a simple "Value cannot be more than 50,000.00 please re-enter".

Is there a way to do this at the DB level instead of the Try/Catch method in the App code?

Thanks

John