SQL: WHERE fldTest <> ’value’ ??
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9433
Printed Date: 29 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL: WHERE fldTest <> ’value’ ??
Posted By: Necronom
Subject: SQL: WHERE fldTest <> ’value’ ??
Date Posted: 01 February 2004 at 1:47am
|
Is there a way to structure a sql string so that it polls data where a certain value doesn't exist? Here's kinda want I'm looking to do: SELECT tblTable.* FROM tblTable WHERE fldField <> 'Value'; or even SELECT tblTable.* FROM tblTable WHERE fldField <> ''; (for a blank field) TIA . necronom . |
Replies:
Posted By: MadDog
Date Posted: 01 February 2004 at 1:54am
|
that should work. Something like this would also work: SELECT tblTable.* FROM tblTable WHERE NOT fldField = 'Value'; ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: Necronom
Date Posted: 01 February 2004 at 2:03am
|
Thank you! . necronom . |