try <> 6
> 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_t
> alk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
------------------------------------------------------------------------------
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.
