Ricardo were using EMPTY() function on a field in the view result cursor not in a view definition itself.
>( catching up on old messages )
>
>I'm confused - is EMPTY() a legitimate function in a remote view or is this not what he's doing ? I can't find EMPTY() in any SQL Server documentation and I am testing for empty character strings with field = '' where local views used EMTPY(field) - is there a better way ?
>
--sb--