|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
What's wrong with this sql statement
I want the number of the plans that have an empty title. So a list of plans that have no title (yet).
I use this in an access query. SELECT tblplans.plannumber,tblplans.title FROM tblplans WHERE IsEmpty(tblplans.title); I'v made some empty fields but he doesn't show them in the query. I get an empty query. Any of you know whats wrong? Tx |
|
#2
|
|||
|
|||
|
Try
SELECT tblplans.plannumber,tblplans.title FROM tblplans WHERE tblplans.title is null |
|
#3
|
||||
|
||||
|
Or
Code:
SELECT tblplans.plannumber, tblplans.title FROM tblplans WHERE title IS NULL OR title = '' |
|
#4
|
|||
|
|||
|
Ok tx.
I used IsNull but not Is Null. Damn spaces. But thanks a lot. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > What's wrong with this sql statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|