C#检索access数据库时如何将文本字段转换成数字

时间:2016-06-07 15:50:12 来源:互联网 作者: 神秘的大神 字体:

可以参考以下例子,table1.a为字符串,table2.b为数值 select a from Table1 where val(a) in (select b from Table2) or select a from Table1 where a in (select str(b) from Table2) or select a from Table1 where a in (select cstr(b) from Table2) o

可以参考以下例子,table1.a为字符串,table2.b为数值

select a from Table1 where val(a) in (select b from Table2)
or
select a from Table1 where a in (select str(b) from Table2)
or
select a from Table1 where a in (select cstr(b) from Table2)
or
select a from Table1 where a in (select format(b,'#####') from Table2)