We get data from a linked Excel Spreadsheet and I found what appeared to be a space at the end of a text field in one of the records. Since that wouldn't match the existing data in our database I applied the Trim function to the field to remove the space. That didn't work. So to see what I was dealing with I put
in the query. The result for the this for the record in question was 160. That's outside of the range of ASCII characters. Does anyone know what this is and have suggestions on how get rid of it?
Note the character appears as white space in the spreadsheet too.
Code:
RM: Asc(Right([Tracker].[PromoDesc],1))
in the query. The result for the this for the record in question was 160. That's outside of the range of ASCII characters. Does anyone know what this is and have suggestions on how get rid of it?
Note the character appears as white space in the spreadsheet too.