[AccessD] Zero-width characters in query

Rocky Smolin rockysmolin at bchacc.com
Thu May 25 09:54:53 CDT 2017


Not a solution but if you retrieved the second character in the string in
the event that the fist character was blank or null, would that second
character actually be the first character in the string?  Or be the second
character?

Rocky


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Wednesday, May 24, 2017 10:49 PM
To: Access Developers discussion and problem
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



More information about the AccessD mailing list