OK, next question:

I built a view to test using the above udf and this works:

SELECT     mail, sn, givenname

FROM         dbo.udf_GetEMpsBYManager('115898') udf_GetEMpsBYManager

Now, I don't want to be hardcoding employeeid's so I wrote a scalar udf, udf_GetEmployeeID that takes a full or partial name and returns a 6 character employeeid. I tried to code that into the view, i.e.:

SELECT     mail, sn, givenname

FROM         dbo.udf_GetEMpsBYManager(dbo.GetEmployeeid('Schaefer'))udf_GetEMpsBYManager

But I get an error message:

Error in list of function arguments: '.' not recognized.

Incomplete parameters list.

Unable to parse query text.

Can I call a scalar udf in the invocation of a table udf in a view?

There's a good one for you, huh?