>Hi there! I use LIKE expression in SQL Path Trough. But Vfp does’ not understand this expression. And tell “Command contains unrecognized phrase/keyword”. Here it’s:
>_cliptext = _cliptext + IIF(EMPTY(lcbui_adr),'',
' and bui_adr like '%Serycheva%')
>Please help.
If this was copied and pasted, looks like you're missing an end quote in the bolded part above.
Try this instead
_cliptext = _cliptext + IIF(EMPTY(lcbui_adr),'', " and bui_adr like '%Serycheva%'")
HTH
Insanity: Doing the same thing over and over and expecting different results.