473,320 Members | 1,909 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to query a NULL value in a Text formatted Table Column?

How Can You Successfully Query a NULL value in a Text formatted Table Column? This is a known problem per internet articles I have read and I cannot get the query to execute properly.
Sep 30 '10 #1
1 1262
MMcCarthy
14,534 Expert Mod 8TB
Can you post the query you are trying to run? Normally using the NZ() function on the field you are querying works.

Expand|Select|Wrap|Line Numbers
  1. NZ([MyFieldName],"")
Then set the criteria to "" to get the results.
Sep 30 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Jagdip Singh Ajimal | last post by:
I am creating the following view CREATE OR REPLACE VIEW AllMedics AS SELECT * FROM Medic m, Employee e WHERE e.EmployeeID = m.MedicID AND e.DateFinished = NULL; But all I get is "no rows...
2
by: crjunk | last post by:
I have a text box that records a date. If the user enters a date in the text box, and click on save, the date will be saved in the SQL table, but if the user does not enter a date in this field...
3
by: Jimmy Crider | last post by:
Hello all, Here is my code to check the Null value in a column. Please let me know the way I coded can be fine tuned. If Not Covert.IsDBNull(mycommandObject.Parameters("MycoulmnName").Value)...
1
by: Jay | last post by:
On my aspx page I have a FormView with a RadioButtonList bound to a column on a DataSource table. The form starts up in Edit mode. I want the formView to start up with nothing yet selected in the...
0
by: hardieca | last post by:
Hi, My formview or gridview control stops updating or deleting a record once the record has a null value. I have table tblTest with the following pkID int NOT NULL **IDENTITY COLUMN**...
5
by: =?Utf-8?B?bWNhdWxpZmZl?= | last post by:
I have an old application ( pre-VB5) that I need to add a select/option list to. This is an edit program so the values for the form will be retrieved from a database. How do I set the value of...
3
by: =?Utf-8?B?UmljaCBIdXRjaGlucw==?= | last post by:
I'm not really sure how to ask this question because I'm still getting my feet wet with data access and VB.NET, but here goes: To start off with, I'm using VB 2005 Express to connect to an Access...
3
by: Gilberto | last post by:
Hello i have 7 tables, 7 forms and one query calculating a total for each table. Everything works perfect but every time i delete all the records from the tables ("clean") if i run the query it...
0
by: =?UTF-8?B?SXbDoW4gU8OhbmNoZXogT3J0ZWdh?= | last post by:
rynato wrote: Variable bindings. Have a look at the PHP manual, the section about PDO and binding variables into a prepared query. Cheers, -- ---------------------------------- Iván...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.