(Its classic client v5. SQL server 2005)
here is a strange problem , i faced and do not have a root cause yet .
WE have a report on table cust ledg entry. , it has various filters on posting date document no. etc.
What I have noticed that if the filter is set on document no. it will give me different results when the fitler is
SNO12.. vs SNO12*
I am pretty sure its a SQL related issue but not sure what is the proper solution . We told the customer to use the filter one way