I have a string field that is 50 char in length. My data is about 10 char but it can vary so I left the default as 50. When I do a query and search for a specific string, the query does not return a string I know exists in the table. When I do (Like "*<string>") it finds the string. Is Access hiding some leading string values I can't see?
The string values are generated by concatenating a number (converted with the str function) and another string. Is Access keeping leading zeroes from the number?
Thanks
The string values are generated by concatenating a number (converted with the str function) and another string. Is Access keeping leading zeroes from the number?
Thanks