[AccessD] Zero-width characters in query

[Charlotte Foust]

Using the Asc() function on the first character is how I discovered the
problem.

Charlotte Foust
916-206-4336

On May 25, 2017 5:45 AM, "Gustav Brock" <gustav at cactus.dk> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>