access查询长字符串怎么返回空，求指教

aciom 2021-12-09 16:52:49

各位大佬，一条简单的查询语句怎么返回空值，是因为数字串太长的原因吗？

字段“用户”查询的话就可以。

感谢！

SELECT  * FROM STA231_2021_11 where 条码 = "110123105216680740012302211109C";

**STA231_2021_11**
时间	用户	检具	条码	合格判断	D1X_Noml	D1X_Meas	D1X_USL	D1X_LSL	D1Y_Noml	D1Y_Meas	D1Y_USL	D1Y_LSL	D2X_Noml	D2X_Meas	D2X_USL	D2X_LSL	D2Y_Noml	D2Y_Meas	D2Y_USL	D2Y_LSL	D3X_Noml	D3X_Meas	D3X_USL	D3X_LSL	D3Y_Noml	D3Y_Meas	D3Y_USL	D3Y_LSL	D4X_Noml	D4X_Meas	D4X_USL	D4X_LSL	D4Y_Noml	D4Y_Meas	D4Y_USL	D4Y_LSL	D5X_Noml	D5X_Meas	D5X_USL	D5X_LSL	D5Y_Noml	D5Y_Meas	D5Y_USL	D5Y_LSL	D6X_Noml	D6X_Meas	D6X_USL	D6X_LSL	D6Y_Noml	D6Y_Meas	D6Y_USL	D6Y_LSL	D7X_Noml	D7X_Meas	D7X_USL	D7X_LSL	D7Y_Noml	D7Y_Meas	D7Y_USL	D7Y_LSL	D8X_Noml	D8X_Meas	D8X_USL	D8X_LSL	D8Y_Noml	D8Y_Meas	D8Y_USL	D8Y_LSL	D9_Noml	D9_Meas	D9_USL	D9_LSL	D10_Noml	D10_Meas	D10_USL	D10_LSL	D11_Noml	D11_Meas	D11_USL	D11_LSL
2021/11/18 星期四下午 4:14:14	User	STA231	110123105216680740012302211109	Fail	13.500000	13.479300	1.000000	-1.000100	13.500000	15.550200	1.000000	-1.000000	13.500000	13.478300	1.000000	-1.000000	13.500000	13.459100	1.000000	-1.000000	13.500000	15.833600	1.000000	-1.000000	13.500000	15.429000	1.000000	-1.000000	13.500000	14.687100	1.000000	-1.000000	13.500000	13.479500	1.000000	-1.000000	13.500000	13.479300	1.000000	-1.000000	13.500000	15.306200	1.000000	-1.000000	13.500000	13.478300	1.000000	-1.000400	13.500000	13.481000	1.000000	-1.000000	13.500000	15.265200	1.000000	-1.000000	13.500000	14.948500	1.000000	-1.000000	13.500000	14.710800	1.000000	-1.000000	13.500000	13.479500	1.000000	-1.000000	43.000000	52.335000	1.000000	-1.000000	43.000000	53.232300	1.000000	-1.000000	50.800000	51.371300	1.000000	-1.000000
2021/11/18 星期四下午 4:29:26	User	STA231	110123105216680740012635211109	Fail	13.500000	13.479300	1.000000	-1.000100	13.500000	17.187400	1.000000	-1.000000	13.500000	13.478300	1.000000	-1.000000	13.500000	13.457200	1.000000	-1.000000	13.500000	15.747000	1.000000	-1.000000	13.500000	15.426000	1.000000	-1.000000	13.500000	15.338600	1.000000	-1.000000	13.500000	13.479500	1.000000	-1.000000	13.500000	13.479300	1.000000	-1.000000	13.500000	15.877400	1.000000	-1.000000	13.500000	13.478300	1.000000	-1.000400	13.500000	13.457200	1.000000	-1.000000	13.500000	15.613200	1.000000	-1.000000	13.500000	15.291900	1.000000	-1.000000	13.500000	15.123200	1.000000	-1.000000	13.500000	13.479500	1.000000	-1.000000	43.000000	52.014300	1.000000	-1.000000	43.000000	53.189300	1.000000	-1.000000	50.800000	51.367500	1.000000	-1.000000
2021/11/18 星期四下午 4:32:47	User	STA231	110123105216680740012635211109	Fail	13.500000	13.479300	1.000000	-1.000100	13.500000	17.205900	1.000000	-1.000000	13.500000	13.478300	1.000000	-1.000000	13.500000	13.457200	1.000000	-1.000000	13.500000	15.763800	1.000000	-1.000000	13.500000	15.425600	1.000000	-1.000000	13.500000	15.363500	1.000000	-1.000000	13.500000	13.479500	1.000000	-1.000000	13.500000	13.479300	1.000000	-1.000000	13.500000	15.883000	1.000000	-1.000000	13.500000	13.478300	1.000000	-1.000400	13.500000	13.457200	1.000000	-1.000000	13.500000	15.618000	1.000000	-1.000000	13.500000	15.301600	1.000000	-1.000000	13.500000	15.119400	1.000000	-1.000000	13.500000	13.479500	1.000000	-1.000000	43.000000	52.109300	1.000000	-1.000000	43.000000	53.187200	1.000000	-1.000000	50.800000	51.365600	1.000000	-1.000000
2021/11/18 星期四下午 4:54:18	User	STA231	110123105216680740012635211109C	Pass	13.500000	13.500900	1.000000	-1.000100	13.500000	13.513800	1.000000	-1.000000	13.500000	13.462900	1.000000	-1.000000	13.500000	13.456100	1.000000	-1.000000	13.500000	13.502800	1.000000	-1.000000	13.500000	13.502500	1.000000	-1.000000	13.500000	13.504100	1.000000	-1.000000	13.500000	13.505600	1.000000	-1.000000	13.500000	13.497400	1.000000	-1.000000	13.500000	13.497400	1.000000	-1.000000	13.500000	13.462900	1.000000	-1.000400	13.500000	13.456100	1.000000	-1.000000	13.500000	13.499300	1.000000	-1.000000	13.500000	13.500400	1.000000	-1.000000	13.500000	13.499400	1.000000	-1.000000	13.500000	13.498500	1.000000	-1.000000	43.000000	43.022700	1.000000	-1.000000	43.000000	43.021300	1.000000	-1.000000	50.800000	50.797400	1.000000	-1.000000
2021/11/19 星期五上午 9:42:06	User	STA231	110123105216680740010016211014A	Pass	13.500000	13.490500	1.000000	-1.000100	13.500000	13.487100	1.000000	-1.000000	13.500000	13.462900	1.000000	-1.000000	13.500000	13.456100	1.000000	-1.000000	13.500000	13.485300	1.000000	-1.000000	13.500000	13.486000	1.000000	-1.000000	13.500000	13.488900	1.000000	-1.000000	13.500000	13.487600	1.000000	-1.000000	13.500000	13.489900	1.000000	-1.000000	13.500000	13.487800	1.000000	-1.000000	13.500000	13.462900	1.000000	-1.000400	13.500000	13.456100	1.000000	-1.000000	13.500000	13.485900	1.000000	-1.000000	13.500000	13.487100	1.000000	-1.000000	13.500000	13.488900	1.000000	-1.000000	13.500000	13.488300	1.000000	-1.000000	43.000000	43.022800	1.000000	-1.000000	43.000000	43.021500	1.000000	-1.000000	50.800000	50.803300	1.000000	-1.000000
2021/11/23 星期二下午 1:44:13	Manager	STA231	110123105216680740010290211118A	Pass	13.500000	13.503200	1.000000	-1.000100	13.500000	13.496200	1.000000	-1.000000	13.500000	13.477000	1.000000	-1.000000	13.500000	13.475200	1.000000	-1.000000	13.500000	13.481500	1.000000	-1.000000	13.500000	13.482000	1.000000	-1.000000	13.500000	13.481900	1.000000	-1.000000	13.500000	13.486700	1.000000	-1.000000	13.500000	13.493000	1.000000	-1.000000	13.500000	13.488100	1.000000	-1.000000	13.500000	13.479600	1.000000	-1.000400	13.500000	13.480600	1.000000	-1.000000	13.500000	13.481800	1.000000	-1.000000	13.500000	13.482100	1.000000	-1.000000	13.500000	13.481000	1.000000	-1.000000	13.500000	13.484400	1.000000	-1.000000	43.000000	43.056100	1.000000	-1.000000	43.000000	43.028600	1.000000	-1.000000	50.800000	50.802700	1.000000	-1.000000
2021/11/23 星期二下午 1:45:27	Manager	STA231	110123105216680740010290211118A	Pass	13.500000	13.503100	1.000000	-1.000100	13.500000	13.496500	1.000000	-1.000000	13.500000	13.477000	1.000000	-1.000000	13.500000	13.475200	1.000000	-1.000000	13.500000	13.481500	1.000000	-1.000000	13.500000	13.482000	1.000000	-1.000000	13.500000	13.482000	1.000000	-1.000000	13.500000	13.486800	1.000000	-1.000000	13.500000	13.493000	1.000000	-1.000000	13.500000	13.488000	1.000000	-1.000000	13.500000	13.479700	1.000000	-1.000400	13.500000	13.480700	1.000000	-1.000000	13.500000	13.481700	1.000000	-1.000000	13.500000	13.482300	1.000000	-1.000000	13.500000	13.481000	1.000000	-1.000000	13.500000	13.484400	1.000000	-1.000000	43.000000	43.058500	1.000000	-1.000000	43.000000	43.028600	1.000000	-1.000000	50.800000	50.801100	1.000000	-1.000000

...全文

469 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

易登软件Access开发 2022-01-26

打赏
举报


SELECT  * FROM STA231_2021_11 where isnull(条码,'')=''

xiaodz2007 2021-12-25

打赏
举报

可以试试SELECT * FROM STA231_2021_11 where trim'（条码）= "110123105216680740012302211109C"

一个基于Socket,用vb.net写的计帐程序,分服务器与客户短基本上很简单,代码很乱,用...只能将它分解成字符串传递,觉得用xml来传递则会产生很多字节,占用流量而影响速度,不知道是不是会这样,总之,我用字节传递是很慢的

标题: 【原创】WinDbg学习笔记（二）--字符串访问断点作者: gaorqing 时间: 2009-07-25,21:39:04 链接: http://bbs.pediy.com/showthread.php?t=94326 WinDbg学习笔记（二）--字符串访问断点一、...

字符串实战简单回顾eval与exec简介字符串的简单规范字符串的截取字符串赋值规范字符串转义字符字符串常见运算符字符串格式化字符串格式化强化字符串编码简介dir与help查看str字符串函数第一个大写以及字符串居中...

逐个字符判断，是否为 "+-0123456789." 中的一个，取出连续的数值部分问题不明确啊比如： dim s as string dim v as long s="123abc456efg" 如果你只要123，那么有现成的函数： v=...

间:2010-09-11 12:47:59作　者:摘　要:字符分段提取正　文:有时候一个字段里面存储了几句话，我们想按分号或者句号，分段提取，并存储到另外的表中，可以用这样的方法，我是初学，也许还有更好的方法，请大家指教。...

Access

7,712

社区成员

28,799

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章