Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL: WHERE fldTest <> ’value’ ??
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL: WHERE fldTest <> ’value’ ??
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Necronom View Drop Down
Groupie
Groupie


Joined: 19 October 2001
Location: United States
Status: Offline
Points: 116 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Necronom Quote  Post ReplyReply Direct Link To This Post Topic: SQL: WHERE fldTest <> ’value’ ??
    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 .
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2004 at 1:54am

that should work.

Something like this would also work:

SELECT tblTable.* FROM tblTable WHERE NOT fldField = 'Value';
Back to Top
Necronom View Drop Down
Groupie
Groupie


Joined: 19 October 2001
Location: United States
Status: Offline
Points: 116 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Necronom Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2004 at 2:03am

Thank you!

. necronom .
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.