C#检索access数据库时如何将文本字段转换成数字
- WBOY原創
- 2016-06-07 15:50:122053瀏覽
可以参考以下例子，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)
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn