Sorry I meant comparing them to eg customer.number01 or whatever number field in the table.
Chris Thompson
Chris Thompson
On 13 Jun 2013, at 12:01, brenda mohr <brenda@...> wrote:
> I have run into this in the past and checking for the ASCII seem to work. The ones I tend to use are
> CHR(032) –Space
> CHR(127) – Delete (This is usually the culprit in my cases)
>
> Brenda
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
> Sent: Wednesday, June 12, 2013 2:52 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] My BAQ to find blank bins did not work with " NULL", but did work with < "-".
>
>
>
> Did you try comparing it to a character field or number field?
>
> Chris Thompson
>
> On 12 Jun 2013, at 18:00, "Len Hartka" <len.hartka@...<mailto:len.hartka%40sunautomation.com>> wrote:
>
> > Good Day:
> >
> > My BAQ to find blank bins did not work with " NULL", but did
> > work with < "-".
> >
> > Does that mean there is ""Some non-displaying thing" in the
> > field. How do I get its ASSCII code - or 'see' it.
> >
> > Len
> >
> > This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]