>>Hi
>>I want to search the last record having some text
>>
>>mytext="ABC"
>>?SQLEXEC(lnHandle,"select ac from account where ac like '%'+mytext+'%' order by ac desc limit 1","tmp")
>>this return value -1
>>but
>>?SQLEXEC(lnHandle,"select ac from account where ac like '%ABC%' order by ac desc limit 1","tmp")
>>return value 1
>>
>>so how to combine "%" together with variable mytext ?
>
>Try
>
>
?SQLEXEC(lnHandle,"select top 1 ac from account where ac like '%'+?mytext+'%' order by ac desc limit 1","tmp")
Doesn't look right to me
>Top 1 to get the only one last record matching the criteria.
Gregory