I have values in a table that are varchar but I want them to be decimal(15,5):
When I use round(cast(a1 as real),5), I get:
When I use cast(cast(a1 as real) as decimal(15,5)), I get:
What do I do to get:
from the values?