[AccessD] Zero-width characters in query

David McAfee davidmcafee at gmail.com
Thu May 25 18:24:09 CDT 2017


This is what i had to do when i dealt with mdb files coming back from the
state and county. Drove me nuts tryimg to figure out why nz([AidCode],"")
<>"" was not picking up blanks

On May 25, 2017 7:47 AM, "Charlotte Foust" <charlotte.foust at gmail.com>
wrote:

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