I'm using this piece of code to get the number of search results. However it says- Incorrect syntax near ')' (the very last ')' )
SELECT COUNT(*) FROM
(SELECT ID, ProductDescription FROM Products WHERE ProductDescription LIKE '%tech%')
The inner select works fine and gives correct results, so I don't understand what's the problem... I won't be surprised if it's something stupid, but I've tried lots of things but with no success..
So I hope you guys can give some hints.