>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")
Top 1 to get the only one last record matching the criteria.
If it's not broken, fix it until it is.
My Blog