SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Puzzling SELECT results
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mondeo
Constraint Violating Yak Guru

285 Posts

Posted - 09/26/2007 :  06:34:30  Show Profile  Reply with Quote
I have this

SELECT id, name, locationid, categoryid, keywords, imagetype, priority
FROM dbo.fin_images
WHERE (categoryid LIKE '%1:%') OR
(categoryid LIKE '%2:%') OR
(categoryid LIKE '%3:%') OR
(categoryid LIKE '%4:%') OR
(categoryid LIKE '%5:%') OR
(categoryid LIKE '%43:%') OR
(categoryid LIKE '%68:%') OR
(categoryid LIKE '%30:%') OR
(categoryid LIKE '%46:%') OR
(categoryid LIKE '%69:%') OR
(categoryid LIKE '%71:%') OR
(categoryid LIKE '%72:%') OR
(categoryid LIKE '%73:%') OR
(categoryid LIKE '%74:%') OR
(categoryid LIKE '%56:%') OR
(categoryid LIKE '%57:%') OR
(categoryid LIKE '%59:%') OR
(categoryid LIKE '%62:%') OR
(categoryid LIKE '%61:%') OR
(categoryid LIKE '%63:%') OR
(categoryid LIKE '%64:%') OR
(categoryid LIKE '%65:%') OR
(categoryid LIKE '%40:%') OR
(categoryid LIKE '%41:%') OR
(categoryid LIKE '%44:%') OR
(categoryid LIKE '%66:%') OR
(categoryid LIKE '%67:%')

It returns results when categoryid is

:6:75:80:
:7:76:84:

Cant seem to see where I went wrong

Thanks

madhivanan
Premature Yak Congratulator

India
22744 Posts

Posted - 09/26/2007 :  06:44:35  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Nothing wrong

:6:75:80: is satisfied by categoryid LIKE '%5:%' and
:7:76:84: is satisfied by categoryid LIKE '%4:%'



Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30111 Posts

Posted - 09/26/2007 :  07:01:35  Show Profile  Visit SwePeso's Homepage  Reply with Quote
For '%44:%', you also get 144, 244, 234243244 and so on...
SELECT	id,
	name,
	locationid,
	categoryid,
	keywords,
	imagetype,
	priority
FROM	dbo.fin_images
WHERE	':' + categoryid + ':' LIKE '%:1:%'
	OR ':' + categoryid + ':' LIKE '%:2:%'
	OR ':' + categoryid + ':' LIKE '%:3:%'
	OR ':' + categoryid + ':' LIKE '%:4:%'
	OR ':' + categoryid + ':' LIKE '%:5:%'
	OR ':' + categoryid + ':' LIKE '%:43:%'
	OR ':' + categoryid + ':' LIKE '%:68:%'
	OR ':' + categoryid + ':' LIKE '%:30:%'
	OR ':' + categoryid + ':' LIKE '%:46:%'
	OR ':' + categoryid + ':' LIKE '%:69:%'
	OR ':' + categoryid + ':' LIKE '%:71:%'
	OR ':' + categoryid + ':' LIKE '%:72:%'
	OR ':' + categoryid + ':' LIKE '%:73:%'
	OR ':' + categoryid + ':' LIKE '%:74:%'
	OR ':' + categoryid + ':' LIKE '%:56:%'
	OR ':' + categoryid + ':' LIKE '%:57:%'
	OR ':' + categoryid + ':' LIKE '%:59:%'
	OR ':' + categoryid + ':' LIKE '%:62:%'
	OR ':' + categoryid + ':' LIKE '%:61:%'
	OR ':' + categoryid + ':' LIKE '%:63:%'
	OR ':' + categoryid + ':' LIKE '%:64:%'
	OR ':' + categoryid + ':' LIKE '%:65:%'
	OR ':' + categoryid + ':' LIKE '%:40:%'
	OR ':' + categoryid + ':' LIKE '%:41:%'
	OR ':' + categoryid + ':' LIKE '%:44:%'
	OR ':' + categoryid + ':' LIKE '%:66:%'
	OR ':' + categoryid + ':' LIKE '%:67:%'



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000