hostfreak Posted September 13, 2006 Share Posted September 13, 2006 I was wondering if there was any way to select fields that don't: == '' (have an equivalence of blank), from the query? I have a field that contains an edit date, but if it has never been edited it won't contain anything therefore it will be blank. I guess if there is no way, I could always make the ones without an edit date null and make that field null by default. Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted September 13, 2006 Share Posted September 13, 2006 Use != instead of == or if you want to check if the field is empty then just ='' Quote Link to comment Share on other sites More sharing options...
hostfreak Posted September 13, 2006 Author Share Posted September 13, 2006 Ah, got it. Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.