Is there a way a parameter can take both int type and varchar type of values? I have a search field whose value is being passed in as a parameter and that value can be either a varchar or an int value. I know I can sort it out by have two different parameter field one which is varchar and the other int.
Thanks!