Does
And CaseDetail.StatusID NOT LIKE '%6%'
work?
best, paul
At 10:39 PM 9/12/00 -0700, you wrote:
>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.
------------------------------------------------------------------------------
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.
