How to verify that a user has entered only alphanumeric characters 1

[slaver]

HI,

IS IT POSSIBLE TO verify that a user has entered only alphanumeric characters IN SQL SERVER.

I KNOW THE VARIOUS METHODS ON THE CLIENT SIDE, BUT I NEED TO DO THIS IN SQL SERVER THROUGH A STORED PROCEDURE OR TRIGGER OR RULE OR CONSTRAINT.

THE BEST I CAN COME UP WITH SO FAR IS:

CREATE RULE vchar_input_rule
AS @vchar_input not like '%?%'
GO
EXEC sp_bindrule vchar_input_rule, 'tbl_gData_Person.vchar_Surname'

IS THERE ANOTHER WAY ?

THANKS

 

[karluk]

I think the following rule will work:

CREATE RULE vchar_input_rule
AS @vchar_input not like '%[^0-9,^A-Z,^a-z]%'