Guest Amadeus2009 Posted September 18, 2009 Report 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 Report 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
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now