将Float转换为Varchar [英] Convert Float to Varchar

问题描述

我有一个电话号码为FLOAT的旧表.我想将其转换为VARCHAR.示例:

I have a legacy table with a phone number as FLOAT. I would like to convert it to VARCHAR. Example:

SELECT
    [PhoneNumber01] AS FloatPhone,
    CONVERT(varchar(50), PhoneNumber01, 2) AS ConvertPhone,
    CAST([PhoneNumber01] AS VARCHAR(15)) AS CastPhone
FROM OurTable

输出为:
< text>
FloatPhone ----- ConvertPhone --------------- CastPhone
9995553605 ---- 9.995553605000000e + 009 ---- 9.99555e + 009

有没有一种解决方案，或者我需要使用字符串操作来删除多余的内容(科学记数法)吗?

谢谢
djj

with the output of:
<text>
FloatPhone ----- ConvertPhone --------------- CastPhone
9995553605 ---- 9.995553605000000e+009 ---- 9.99555e+009

Is there a one step solution or do I need to use string manipulation to remove extras (scientific notation)?

Thanks
djj

推荐答案

亲爱的您可以使用replace和rtrim组合.这个问题肯定会解决...

谢谢

Dear u can use replace and rtrim combination. surely this problem will resolve...

Thanks

这篇关于将Float转换为Varchar的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！