Guest Amadeus2009 Posted September 18, 2009 Share Posted September 18, 2009 Hey,I'm facing troubles with a small query and am searching for advise:My query is looking like this:select COUNT(product) as Y_Numbersfrom <Name-of-my-Table>where FILTER ='0' AND (product LIKE 'A%')the result of that query is looking like_____|Y_NumbersRow 1| 0If the result is 0, I want the result to be updated to "This filter is working properly".If it is not 0, i want rhe result to be "Filter not working"As you probably see, I'm totaly novice in sql...Thnx for help Link to comment Share on other sites More sharing options...
justsomeguy Posted September 18, 2009 Share Posted September 18, 2009 You can either look into using IF statements inside SQL, or do that check in whatever language is getting the database results. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.