>Cetin,
>
>This will generate a veiw but when I go to modify it I get an error "Not a character expression. I need this view to be updateable.

:) I intentionally added 'force' to make it not updatable (IOW screwable) by designer. Designer can easily screw a view like it. Second version I sent should be designer firendly but results do not mean to be exactly the same. Test SQLs first.
Cetin