>>There is an index on TableFormProperties.TableName, but the date is in mixed case, so I can't do a SEEK (or can I?). I'm doing this in a LOCATE, but that seems a bit wrong somehow. Is this the right way to do it, or is there a better way.
>>
>>lcTableName = "MyTableName"
>>SELECT TableFormProperties
>>LOCATE FOR ALLTRIM(UPPER(TableName) = ALLTRIM(UPPER(lcTableName))
>>
>
>If you index on UPPER(TableName) what's stopping you using a Seek()?
Of course, but sometimes we are not always in control of everything. The index on this data is not UPPER and will not be.