将整数与"varchar字段值"分开 [英] Seperate Integer from a 'varchar field value'

问题描述

你好朋友，
我的数据库表中有一个varchar字段，名称为查询ID".
输入为查询ID:2234"的值.
如何查询分别获取2234作为整数值的查询?????????
例如:查询ID =查询ID:2234"
查询结果= 2234

Hello Friends,
I have a varchar field in my Database Table named ''Enquiry Id''.
Value entering into it As ''Enquiry Id:2234''.
how to wright query for getting 2234 seperately as an integer value?????????
Eg: Enquiry Id=''Enquiry Id:2234''
Query Result=2234

推荐答案

select cast(substring([Enquiry id],12,len([Enquiry Id])) as int) from tablename

试试这个
如果您的列中的字符串"Enquiry id:"是固定的，这将很有帮助.

try this
this will be helpful if this string "Enquiry id:" in your column is fixed.

请参见下文

select REPLACE('Enquiry Id:2234','Enquiry Id:','')

你也可以投

you can cast also

select CAST(REPLACE('Enquiry Id:2234','Enquiry Id:','') as int)

这篇关于将整数与"varchar字段值"分开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！