>I asked about this once before a while back, and nobody seemed to have heard about, but I was too busy to check it out.
>
>The AT() command frequently and consistantly returns 0 when it should not.
>
>lx = "Zip Code"
>ly = "Zip"
>at(lx,ly) returns 0 instead of 1
>
>or
>
>INSERT INTO test1 (test1) VALUES ("My US based Zip Code")
>AT(test1.test1,"Zip") returns 0 instead of 16.
>
>
>Anyone?
You have the parameters in the wrong order. Your first example should be:
...
? at(ly, lx)
...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)