I know the definitions of Seek and Upper(), but what is seek looking for; i.e. using to find "where it's supposed to be"?


>>>>Craig,
>>
>>could you explain what this line is search is looking for?
>>
>>SEEK UPPER(tcTable)
>>
>>I've got :
>>Keys.Table as a regular key
>>Keys.NextId as type intiger
>>Mytable.MyTableId as Primary type intiger
>>
>>I'm getting 1's and 2's, so whatever seek is searching for it's not finding.
>>What am I doing wrong?
>>
>>JD
>
>
>Instead of Keys.Table, it should be UPPER(Table). The UPPER() function forces all characters to be uppercase.