[AccessD] Zero-width characters in query

[Charlotte Foust]

I tried that, but the first character wasn't null, it was a chr(9).  I
replaced it with a null string to cure the craziness.

Charlotte Foust
916-206-4336

On May 25, 2017 7:56 AM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote:

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