I need to create a view that queries a table that contains a column with record data of 1, 2, 3, 4. I'd like the view to update the values to be as follows 1 = A, 2 = D, 3 = L and so on. I cannot change the data in the table I'm making the query, but I need a translation in the view it's going. So, when I query, I get an A where a 1 was, a D where a 2 was. Remember, I cannot update the table it's coming from.