T-SQL Issues With Defining 'AS'
You could try something like this.

declare @command varchar(8000)

set @command = 'select udf_0 as ' + (select udf_0
                                     from tbl_project_desc
                                     where project_name = @project) + 
               ' from table where column = value'

EXECUTE(@command)