Hi,
I have three columns and want to update the third column based on the comparison of first two columns in the same table.
For instance:
Col1 - val1, val2, val3, val4, val5......
Col2 - NULL, NULL, val1, NULL, val2....
Col3 - TRUE, TRUE, FALSE, FALSE, FALSE....
Thanks for any help.