with this like this... you are saying where either of those two things match...
try this: WHERE (ContentOwner is not NULL and ContentOwner LIKE 'A%') tw On 4/2/07, Scott Stewart <[EMAIL PROTECTED]> wrote: > Hey all, > > > > I've got a of SQL query that's returning some unexpected results > > > > select * from > > ( > > SELECT UID, > > Title, > > TranslatedTitle, > > DocumentType, > > Authors, > > Source, > > ContentOwner, > > FulltextLink , > > ROW_NUMBER() OVER (order by ContentOwner, Title, Authors) as recordNumber > > > > FROM PEDisplay2005 > > WHERE ContentOwner is not NULL > > and ContentOwner LIKE 'A%' > > > > > ) as derived > > > > where recordNumber between 1and 10 > > > > What I'm expecting is the first ten records where ContentOwner starts with > A, do not include the records where ContentOwner is null. > > > > What I'm getting is the first ten records where ContentOwners starts with A > *and* the records where ContentOwner is null. > > > > Any ideas? > > > > sas > > > > > > > > > > > > Scott Stewart > ColdFusion Developer > > HYPERLINK > "http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=7241+Jillspring+Ct&csz=Sprin > gfield%2C+VA.+22152&country=us" \n7241 Jillspring Ct > Springfield, VA. 22152 > > > HYPERLINK "mailto:[EMAIL PROTECTED]" [EMAIL PROTECTED] > HYPERLINK "http://www.sstwebworks.com"; \nhttp://www.sstwebworks.com > > > tel: > mobile: > > HYPERLINK > "http://www.plaxo.com/click_to_call?src=jj_signature&To=703-912-3076&Email=s > [EMAIL PROTECTED]" \n703-912-3076 > HYPERLINK > "http://www.plaxo.com/click_to_call?src=jj_signature&To=703-220-2835&Email=s > [EMAIL PROTECTED]" \n703-220-2835 > > > > > > HYPERLINK > "https://www.plaxo.com/add_me?u=25770055805&src=client_sig_212_1_card_join&i > nvite=1" \nAlways have my latest info > > HYPERLINK "http://www.plaxo.com/signature?src=client_sig_212_1_card_sig"; > \nWant a signature like this? > > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.446 / Virus Database: 268.18.24/742 - Release Date: 4/1/2007 > 8:49 PM > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:231758 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
