>>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 would think the second may be a bit better, especially if there is a chance of adding index on UPPER(TableName) in a future. But if the table is small, it would not matter.
If it's not broken, fix it until it is.
My Blog