Home >Database >Mysql Tutorial >C#检索access数据库时如何将文本字段转换成数字
C#检索access数据库时如何将文本字段转换成数字
- WBOYOriginal
- 2016-06-07 15:50:122050browse
可以参考以下例子，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)
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Use C# to access Microsoft Web Browser component programmatiNext article：Access Violation