Hello,
Access 2010 run under Windows 8.1
I have a table with a memo field called "DescriptionLogg". In this memofield I store the word "tataaaa" which does not mean anything but was just for testing.
I tried coincidentally to find the record with a query (SQL in code or with the querybuilder) by searching on:
descriptionlogg like "*tata*" -> result = 0 record
descriptionlogg like "*tataa*" -> result = 1 record
descriptionlogg like "*tataaa*" -> result = 0 record
descriptionlogg like "*tataaaa*" -> result = 1 record
Not trying to lose my faith in SQL I tried it with a different random word
"teteeee" (which does not mean anything either)
descriptionlogg like "*tete*" -> result = 1 record
descriptionlogg like "*tetee*" -> result = 1 record
descriptionlogg like "*teteee*" -> result = 1 record
descriptionlogg like "*teteeee*" -> result = 1 record
Who knows why this difference occurs?
Thanks
Ben
Access 2010 run under Windows 8.1
I have a table with a memo field called "DescriptionLogg". In this memofield I store the word "tataaaa" which does not mean anything but was just for testing.
I tried coincidentally to find the record with a query (SQL in code or with the querybuilder) by searching on:
descriptionlogg like "*tata*" -> result = 0 record
descriptionlogg like "*tataa*" -> result = 1 record
descriptionlogg like "*tataaa*" -> result = 0 record
descriptionlogg like "*tataaaa*" -> result = 1 record
Not trying to lose my faith in SQL I tried it with a different random word
"teteeee" (which does not mean anything either)
descriptionlogg like "*tete*" -> result = 1 record
descriptionlogg like "*tetee*" -> result = 1 record
descriptionlogg like "*teteee*" -> result = 1 record
descriptionlogg like "*teteeee*" -> result = 1 record
Who knows why this difference occurs?
Thanks
Ben