G
Guest
Greetings everyone. I need help with a stored procedure. I need to add a
column to enter a value, either 1,2, or 3 depending on the value of another
field in the query. For example, if the value of the independent field is
'apple' I need the new dependent field to populate '2'. I think I need to do
a case when statement, but I can not get it to work. Is this anywhere close?
case when type_of_fruit= 'apple' then '2'
Do I enter this directly into the column field of the grid pane? Thank you
for any advice or help.
Greg Snidow
column to enter a value, either 1,2, or 3 depending on the value of another
field in the query. For example, if the value of the independent field is
'apple' I need the new dependent field to populate '2'. I think I need to do
a case when statement, but I can not get it to work. Is this anywhere close?
case when type_of_fruit= 'apple' then '2'
Do I enter this directly into the column field of the grid pane? Thank you
for any advice or help.
Greg Snidow