>lcTableName = "MyTableName" >SELECT TableFormProperties >LOCATE FOR ALLTRIM(UPPER(TableName) = ALLTRIM(UPPER(lcTableName)) >It's my opinion that Alltrim() should be avoided as much as possible, unless you really need it. This code will give the same result, and will be much faster if you have an index tag on upper(Tablename). It will also be independent of the Set Exact setting:
lcTableName = "MyTableName" SELECT TableFormProperties lcTableName = padr(lcTableName,len(TableName)) LOCATE FOR UPPER(TableName) == upper(lcTableName)