numeric validation on a varchar field

[TomBarrand]

I am using a varchar field in a table, but ideally I would like to put some validation on the field so that it will only accept integer values. I have to use a varchar as it causes another system a problem if the field is an int.

Any ideas on how I could validate the field would be appreciated.

Thanks

 

[RickCole]

SQL Server 7.0 upwards you could use a check constraint on the coloumn eg:

ALTER TABLE tablename
ADD CONSTRAINT col_number_test CHECK
(column LIKE '[0-9][0-9][0-9][0-9][0-9]')

Rick.