I never came across this weird issue...
I have a product table ProdMaster with a field ProdCode Nvarchar (50), ProdCode are all of different formats like numeric or alphanumeric and of different lenghts.
I recently create through my web interface few products which are showing properly on my page gridview, but when I tried the following select statement directly on the server (Select ProdCode From ProdMaster Where ProdCode ='CFF40179') the ProdCode return blank????
I tried with the "like"word or by using LTRIM/RTRIM but same result.
I could only solved the problem after updating the ProdCode with the same value, and then the select statement returns the correct value.
My concern is to understand what caused this problem, because if I create new products in the future and if they don't show properly in select statement from stored procedure I'l be in trouble.
Expert advice is required...