By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,573 Members | 3,017 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,573 IT Pros & Developers. It's quick & easy.

Simple Query Question

P: n/a
Writing a simple query, and I want a new filed to return true or false
based on if there is info in that field.

For example, my table has a place to store a phone number. I want to
create an expression in my query called PHONE_ENTERED and if the phone
number field in my table is blank, I want PHONE_ENTERED to be False,
otherwise I want it to be true.

This has to be an easy fix, right?

Aug 28 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

igendreau wrote:
Writing a simple query, and I want a new filed to return true or false
based on if there is info in that field.

For example, my table has a place to store a phone number. I want to
create an expression in my query called PHONE_ENTERED and if the phone
number field in my table is blank, I want PHONE_ENTERED to be False,
otherwise I want it to be true.

This has to be an easy fix, right?
why not just search for something like

SELECT <field list>
FROM <some table>
WHERE PhoneNumber IS NULL

or would that be too easy?

Aug 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.