[AccessD] Zero-width characters in query

[James Button]

>From 'fun' with Excel - a leading ' in a string can be a real pain to deal with.

Also there are the not a space 'whitespace' characters that can also cause
annoyance
 ( especially when part of a filename) 

JimB


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Thursday, May 25, 2017 6:49 AM
To: Access Developers discussion and problem <accessd at databaseadvisors.com>
Subject: [AccessD] Zero-width characters in query

I ran into something today that left me scratching my head.  I ran a query
to extract the first letter of a company name to use as an index.  About 42
out of some 60k came back empty and no editing I could do would change that.

I hunted around the internet and found a few issues with SharePoint and
Unicode but nothing that made sense in context.  Have any of you ever
happened on this?  I found a way to fix the fields, because i could find no
way to query around it.  The length of the string was for the visible
characters, but the first character wasn't visible.

Charlotte Foust
916-206-4336
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com