Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chipembele
Posting Yak Master
106 Posts |
 Posted - 2009-11-03 : 04:12:06
|
| HiI know how to find NULLs by using IS NULL but can anyone advise on how to search for blank/empty fields. I suspect that if something has been removed from a field it's not a NULL as it was before it was filled. I'm using WHERE fieldname IS NULL or fieldname " "any advice appreciated. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-03 : 04:17:14
|
| WHERE fieldname IS NULL or fieldname = ''MadhivananFailing to plan is Planning to fail |
 |
|
|
chipembele
Posting Yak Master
106 Posts |
Posted - 2009-11-03 : 04:30:05
|
| ThanksIs that one of these " or two of these ' ' |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-03 : 04:32:13
|
| it is two single quotesMadhivananFailing to plan is Planning to fail |
|
|
|
chipembele
Posting Yak Master
106 Posts |
Posted - 2009-11-03 : 04:33:20
|
| Thankyou |
|
|
|
|
|
|
Searching Null and Blank