>Are now moving to sqlserver from sybase and are testing new applications with the database, but it has created a problem: many of the queries that are running are generating the error Ambiguous column name are dozens of screens that are presenting this problem not occurred in sybase. Is there some command to make consistent sybase queries that generated no problem?.
>
>The queries are in each form and invoked with SQLEXEC ()
>
>Sample :
>
>work fine in Sybase but not in sqlserver
>
>select DESC_PROF,CODI_PROF,DESC_PROF from PROF order by DESC_PROF
>
>thank you very much for your help.

You have DESC_PROF twice, change the alias of one of the columns if you really need to have it twice, i.e. select DESC_PROF,CODI_PROF,DESC_PROF as NEW_DESC_PROF from PROF order by DESC_PROF