>Hi, I have some remote views on an oracle db. Oracle does not support boolean types in it's tables so all the boolean data in those tables is encoded with a CHAR(1) containing either 'T' or 'F'.
>
>Is there anyway to have the remote views return .T. or .F. depending on the content of the field ?
>
>I first tried adding an expression with the view builder : iif(boolField, true, false) as boolField but it added this with " in the sql code so it did not work.
>
>I tried to create a view with such expressions by hands but the creation process does not work.
>
>TIA

Try an expression like :

myField = 'T'

Cetin