Hi,
     I have created a function test under the user name tom.dick under the database TELEVISION.

     I executed the following sql in the query analyzer
SELECT TOP 1 CLIENT_NO, ACCOUNT,
    tom.dick.test(CLIENT_NO),
    tom.dick.test(CLIENT_NO)
FROM test_table
ORDER BY CLIENT_NO

I get the following error
Invalid object name 'tom.dick.test'.

I change the SQL to the following
SELECT TOP 1 CLIENT_NO, ACCOUNT,
    TELEVISION.tom.dick.test(CLIENT_NO),
    TELEVISION.tom.dick.test(CLIENT_NO)
FROM test_table
ORDER BY CLIENT_NO

I get the following error
The object name 'TELEVISION.tom.dick.' contains more than the maximum number of prefixes. The maximum is 2.

Please let me know as to how I solve this problem.

Thanks in advance