>Hi
>
>I had a strange problem with a program an discovered that the index had been created on a numeric value while the seek() was searching for a character expression. I got the following strange results when Zero was one of the values in the table. Is this a bug in the Seek() function?
>
>I am using VFP 7.0 SP1 and WinXP Pro SP1. I get the same results in VFP 8.0 SP1.
>
>
>

>Create Table UPTest (Number N(5,0))
>Select UPTest
>Index On Number Tag Number
>Insert Into UPTest (Number) VALUES (1)
>Insert Into UPTest (Number) VALUES (2)
>Insert Into UPTest (Number) VALUES (3)
>
>? Seek("Mary","UPTest","Number")    && .F. as expected
>
>? Seek("mary","UPTest","Number")    && .F. as expected
>
>? Seek("0Mary","UPTest","Number")    && .F. as expected
>
>Insert Into UPTest (Number) VALUES (0)
>
>? Seek("Mary","UPTest","Number")    && .T.  ???
>
>? Seek("mary","UPTest","Number")    && .T.  ???
>
>? Seek("0Mary","UPTest","Number")    && .T.  ???
>
>
>Clear All
>Delete File UPTest.dbf
>Delete File UPTest.cdx
>

Simon,
To me it's a bug on development side. It evalueates the string and seeks for a match. If string say has started with 2 then any letter then it'd locate the second whether 0 inserted or not.
Cetin