Using a view to force SQL to SQE

["eftimios pantzopoulos" <eftimios@xxxxxxxxxxx>]

We have an SQL which uses the digits function to convert a field to 
character format for use in a where clause. I understand that this forces 
the SQL to be despatched to the CQE. Would creating a view which performs 
this transformation overcome this problem? In other words create a new 
column which incorporates the digits function on the original table column 
and then use the view instead of the original table in the SQL?



Regards, Mike Pantzopoulos