Hi,
I am passing a varchar value into a stored procedure. This value can be a number string (like '123') or a regular string ('abc'). Inside the sproc, I want to do different things if it is one or the other. I am trying to do something like this.
IF CAST(@val AS INT) returns no error
...do this...
ELSE IF CAST(@val AS INT) returns an error
...do someting else
Can any one tell me how to do this?
Thanks.