ClientDataSet filter with "NOT LIKE"

Question

When using the Filter property of the ClientDataSet with filter

Name NOT LIKE 'Paulo%'

says that the syntax is incorrect.

how can I make a workaround in the filter?

Answer 1

Change the Filter syntax to

  Clientdataset.Filter := 'NOT [Name]  LIKE ' +QuotedStr('Paulo%');