I have an SQL database, which has a table that has constraints on the data that can go in. (ie constrain is that numbers must be between 4000-4999).

what i would like to do, is find out the contraint programatically from ASP. can this be done?

the reason i want to do this, is so that if the user enters bad data, i don't want a bad ADO error thrown...

and i don't want to do client side validation, because the constraint may change....

please let me know if/how it can be done!

dvst8