? CAST(1 AS L), CAST(0 AS L)

>
>We are doing a convertion program and one of the fields we are converting is going from a Interger to a Logical or Bit. IIF() can not be done nicely for this. Does anyone have an other way to do it, Nicely. Example if we were converting a character field to a date field, we just need to do Dtoc() for the inline code to get it to work.
>
>Hope this makes sense.
>Beth