Sorry - got it the wrong way round. Use NOT...
SELECT tblUsers.Us_UserID
FROM tblUsers
WHERE (((tblUsers.Us_UserID) NOT Like '*1*'));
Sponsors of the 1st Northern Information Security Conference
http://www.nisc.org.uk
Sapphire Technologies Ltd.
Secure in the Knowledge
Simon Halcrow Web Developer
E [EMAIL PROTECTED]
T +44 (0)1642 702100
F +44 (0)1642 702119
> -----Original Message-----
> From: Geno [SMTP:[EMAIL PROTECTED]]
> Sent: 13 September 2000 06:39
> To: [EMAIL PROTECTED]
> Subject: I GIVE UP!
>
> I want to select all records from a table that "do not" contain the
> number
> 6.
> Sheesh! Why is it so difficult to select records this way...
>
> the query was
>
> Select *
> From CaseDetail, CaseInfo
> Where CaseDetail.CaseID=CaseInfo.CaseID
> And CaseDetail.StatusID ????????? 6
>
> I've tried NEQ, Does Not Contain, <or!=, Just about everything.... I'm
> lost!
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
