>(SQL2000)
>I have just found that whilst trying to JOIN to a UDF in a WHERE clause that I cannot pass an aliased column from another table as a parameter.
>
>This took a lot of digging on Google and only by accident did I find this mentioned somewhere on MSDN.
>
>Without resorting to converting my hosting query into a cursor driven routine, is there a means by which I can use a column from another table as a parameter ? Is this by design because a column reference is non-deterministic?
>
>This has been fixed in SQL2005, however that isn't (or wasn't) on my budget for this year.

Hi Simon,

Your description of the problem is too sketchy. Can you post your query and, maybe, UDF?