Print Page | Close Window

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 .




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net