>>>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))
>>>
>>
>>It's correct except for the typo.
>>
>>LOCATE FOR ALLTRIM(UPPER(TableName)
) = ALLTRIM(UPPER(lcTableName))
>>
>>Either this or
>>
>>LOCATE FOR UPPER(TableName) = PADR(ALLTRIM(UPPER(lcTableName)),LEN(TableName))
>
>Is one better than the other? The first seems simpler.
I think the second is probably better, for two reasons.
1. If you add an index on UPPER(TableName) it will become optimizable. You will probably never create an index tag that the first expression would optimize.
2. Depending on the status of SET EXACT, the first expression could give a false found() if lcTableName is a partial match for a real TableName.