Thank you so much for the details explanation, I got the problem where it is.

I have used the like operator in the second query to show the difference between, when I use exact match the result is Zero but when i use like operator...

Hi Hugo

Thanks for the suggestions, in fact, I have tried with the first and second suggestion what you have mentioned, but not tried the third one. will check now. I...

Please see the image below i am trying to find out the counts using the exact data stored in the Descrip column when i used the exact data stored in...