如何在sql中将varchar字段转换为int? [英] How to convert varchar field to int in sql?
问题描述
如何转换varchar字段
RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX(' - ',CBFieldName))
到整数?
我的查询如下
$ / b
select *,RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX(' - ',CBFieldName))来自FTSTableDetail的AS TEST
其中TableName ='OUT_CCD'
ORDER BY RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX(' - ',CBFieldName))
如果您的expr的最终结果。 (RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX(' - ',CBFieldName))
)是字母数字,那么你可以使用如下转换或转换函数
< pre lang =JavaScript> CAST(右(CBFieldName,LEN(CBFieldName)-CHARINDEX(' - ',CBFieldName))AS INT)
How to convert the varchar field
RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX('-',CBFieldName))
to integer?
My query is as below
select *,RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX('-',CBFieldName))AS TEST from FTSTableDetail
where TableName='OUT_CCD'
ORDER BY RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX('-',CBFieldName))
If final result of your expr. (RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX('-',CBFieldName))
) is alphanumeric then you can use cast or convert function as follows
CAST(RIGHT(CBFieldName,LEN(CBFieldName)-CHARINDEX('-',CBFieldName)) AS INT)
这篇关于如何在sql中将varchar字段转换为int?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!