No,

You would have to use a sub query in 7.0. In SQL 2000 you can have UDF's embedded in SELECT statements.

>But I can not use this SP as function in SQL query? Or I can?
>For example:
>SELECT ;
> ID,
> MySP(Date) AS kkk
> FROM Table
>
>Giedrius