• I think using cast or convert is your only option if you are just using SSMS. It is using whatever the data type is for your column, so you could reset that if you don't need that precision, unless you are using float.