You can use SQL Pass Through instead.
>Hi all
>Regarding remote views....
>Exists some trick other than creating view programatically to specify "non standard" WHERE clauses?
>More specific, I can include STARTING WITH, CONTAINING, SOME, ANY, etc., keywords in where clause for Firebird server, but, there is no way of doing this in view designer.
>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer