At 04:17 PM 26-09-02 -0400, you wrote:

>We use literals in views all the time and have to cast them to the
>appropriate type.
>
>For some reason this doesn't work with this view.
>
>I get this error:
>"SQL Runner Error
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code=-104
> Invalid command
> Data type unknown"

[snip]

You need to make sure that all corresponding columns in union views match
exactly by data type and size. Your first subset casts a literal as
CHAR(40) whilst the corresponding column in the other subset,
BSS_USER_CONTROL.USER_ID, is VARCHAR(40).

heLen