wish to create sql

SELECT * FROM TABLE WHERE DateModified<LastSync

How do i implement the WHERE cluase?

Will this work?

bucket.PredicateExpression.Add(New FieldCompareValuePredicate(ClientAccountFields.DateModified, Nothing, ComparisonOperator.GreaterThan, ClientAccountFields.LastSync))

You should be using FieldCompareExpressionPredicate

Ref: manual's section Using the generated code -> Adapter/SelfServicing -> Filtering and Sorting -> The predicate system