update column in a view

[pitter1]

Hello all,I'd like to create a view which shows all specific column values (null values for example)as calculated values from another column,if for example i have the table:---------------| col1 | col2||----- |------|| 123 | null || 126 | 9 |---------------i would like the view to be:---------------| col1 | col2 ||------|------|| 123 | 6 | ----> 6, since it's the sum of col1 digits 1+2+3| 126 | 9 |---------------I don't really know how to do that, although i'm quite sure it's possible, any help will be appreciated,Best Regards,pitt