isnull不工作

本文介绍了isnull不工作的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我导入了一个制表符分隔的文本文件，我现在正在尝试选择所有字段 在fieldB中有一个空白字段。 isnull（fieldB） 没有返回 i尝试fieldB ="" =" 我修剪它但仍然没有 我还能尝试什么？ 空白的字段没有空格，他们只是空白。那里的 角色是什么？ 谢谢 解决方案 字段。 isnull（fieldB）没有返回我试过fieldB ="" =" 我修剪它但仍然没有什么 我还能尝试什么？空白的字段没有空格，它们只是空白。什么是 I imported a tab delimted text file and am now trying to select all fieldsthat have a blank field in fieldB. isnull(fieldB)nothing is returnedi tried fieldB = ""= " "I trimmed it and still nothing what else can I try?The fields that are blank have no spaces, they are just blank. What is thecharacter in there? Thanks 解决方案 End If To correctly check IsNull: If IsNull(YourField) Then...whatever hereEnd If --Scott McDanielCS Computer SoftwareVisual Basic - Access - Sql Server - ASP"Jim''s wife" <ta*****@mindspring.com> wrote in messagenews:Kp********************@news4.srv.hcvlny.cv.ne t... I imported a tab delimted text file and am now trying to select all fields that have a blank field in fieldB. isnull(fieldB) nothing is returned i tried fieldB = "" = " " I trimmed it and still nothing what else can I try? The fields that are blank have no spaces, they are just blank. What isthe character in there? Thanksfields that have a blank field in fieldB. isnull(fieldB) nothing is returned i tried fieldB = "" = " " I trimmed it and still nothing what else can I try? The fields that are blank have no spaces, they are just blank. What is the 这篇关于isnull不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！