Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: drew1234567890
- Order by date
-
Equivalent for (X IS NULL OR X IS NOT NULL)
Hi Carp, Thanks for your response. Very helpful! I should have thought of those options. The answer to your question is that my app needs to be able to replace a parameter with a value, and that value could include not caring what is in the field. So, in the following SELECT * FROM Table...- drew1234567890
- Post #4
- Forum: ANSI_SQL
-
Equivalent for (X IS NULL OR X IS NOT NULL)
Hi All, I'm hoping that there is an SQL keyword (e.g. "<KEYWORD>") such that the following statements are all equivalent: SELECT * FROM Table SELECT * FROM Table WHERE (Field IS NULL OR Field IS NOT NULL) SELECT * FROM Table WHERE Field = <KEYWORD> SELECT * FROM Table...- drew1234567890
- Thread
- Replies: 3
- Forum: ANSI_SQL
