I have a requirement to validate a field coming as input parameter to A Stored proc. this field can be only ALPHA Numeric. Ho w I can implement this .
1 ) Is there is any ALPHA numeric Data type in SQL server 2005
2) Is there is a function which can return False or True based on Aphanumeric validation. such that I can call my function from SP it does Alphanumericr validation
Any sql code snippete will be of great help