Is a function the best method/what's the funciton code? Two tables, one table with values that need to be converted from a varchar data type to a money data type, depending on the other's table value. For example,
I have values of:
A means replace A with +1, making table1 value to be 8531
F means replace F with +6, making table1 value to be 576
This requirement is to convert the letter to a number using the lookup table. Table2 has the field1, field2. Field1 is A, field2 is what A means which is 1. Table1 has many values, such as 0000853A. This needs to be updated in this table1 to 00008531....the A turns to a 1.
I'll pass-it's more dynamic.....half way into developing this thing....I guess I'm going to use a function within a cursor to update the individual rows. function will pull from the lookup table a value dependent upon the rendered value by the other table, then update that rendered value.