|
-
I need to write a dynamic if statment as follows.
I have a table with about 50 columns and a part of the procedure is:
if cursor1.col1 > val then...
Now, the "if" statment is always the same the only diferent is that cursor1.col1 might be cursor1.col2, cursor1.col3 ....etc depends on user input/parameter.
My question is, how can I do it with out writing 50 "if" statmenst, some thing like:
if corsor1.col||user_param then
User_parame is a number from 1 - 50
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|