Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQL and confusing results

Author  Topic  millay Starting Member 2 Posts Posted - 2001-08-01 : 06:01:19 Hi all, i do not profess to be an sql guru, so you will all probably laugh when you see what im trying to do. Im gonna paste the offending sql below and then explain whats meant to be happening and what really is :) SELECT * FROM TAB_Episode_Info WHERE (((TAB_Episode_Info.Episode_Genre)='Life Science')) AND (((TAB_Episode_Info.Episode_Name) LIKE '%iss%')) OR (((TAB_Episode_Info.Episode_Listing_Full) Like '% iss%')); basically it should be looking for iss and if it finds the word in either column it should return the row as long as the genre column returns "life science" the problem is it completly ignores the genre column ad just looks for the word "iss". Any help will be gratefully received! Cheers Andy Millea andy@gforce-media.com Edited by - millay on 08/01/2001 06:12:45