Hi Everybody,

I'm trying to select for an item's location in GridView but the Filter doesn't seem to be working. It can't find any items even though I KNOW they are in there. When I don't select for the Location I can see them there. My filter looks like this:

{Loc} = 1

But this doesn't work. I have also tried:

{Loc} = "1"
{Loc} = " 1"
{Loc} = "1 "


Any ideas? The properties for the field say "RCHAR" what does this mean? am I missing some spaces or something?

thanks
Lucas

Nevermind, I figured it out.

It needed TWO spaces after the quotes before the digit, as follows:

{Loc} = " 1"

Any idea why this happens?

Hi, Lucas,

Location is a 3-character alphanumeric field. I tend to use the following:

TRIM({Loc}) = "1"

This will 'trim' the spaces so all you need to enter is the value as you 'see' it.

Ahhh Trim is very helpful!

thanks!