SELECT TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from yourfield)) AS yourfield FROM yourtable WHERE yourfield LIKE '%.% Yourfield: table column name yourtable: table name.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)