On 9/12/00, Geno penned:
>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
Easy.
And CaseDetail.StatusID not like '%6%'
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.
