
Losing Decimal Places While Updating a Column
Question: I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query: update bakset distance = 1/trigwhere trig NULL it executes and gives the correct number, only without the decimal places. For example, one value of