[AccessD] Zero-width characters in query

[Gustav Brock]

Hi Charlotte

You can run a query like

    Select [OffendingField], Asc([OffendingField]) As FirstByte
    From YourTable
    Order By Asc([OffendingField])

to study nasty character.

/gustav

-----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