#1
|
|||
|
|||
MS Query IsNull issue
I have an Excel MS Query that checks a text field (Binloc) for data by the Is Not Null operator using Synergy's ODBC client. This query works and only returns records with Bin locations. In preparation to move to SQL 2008 database the same query returns all records. SQL obvioulsly considers the field space or something other than null. I cannot find an operator that allows me to test both null and space.
Any help is much appreciated. thanks... |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need an Automated sql query for the Excel file | Karthick | Excel | 3 | 12-20-2010 04:52 AM |
Word (Mail Merge) Refreshes Query Too Often! | amarsha4 | Mail Merge | 1 | 11-10-2010 09:12 AM |
Text Box Query | Meljord | Word | 3 | 12-15-2009 12:25 PM |
How to write in Word from Select query | lakhan.p | Word | 0 | 03-27-2009 07:25 AM |
Mail Merge Query | kangabanga | Mail Merge | 0 | 09-25-2008 04:07 AM |