how to Check whether entered parameter is string or int

Question

how to Check whether entered parameter value is string or integer in sql server store procedure

Sibeesh Venu · Answer

Try isnumeric funtion http://stackoverflow.com/questions/9286152/using-if-isnumeric-as-argument USE AdventureWorks2012; GO SELECT City PostalCode FROM Person.Address WHERE ISNUMERIC(PostalCode) 1; GO Please accept and up vote if it helped you Kindest Regards Sibeesh http://sibeeshpassion.com/