>>SELECT TOP 1 *
>> FROM MyTable
>> WHERE Product = ?Parm1
>> ORDER BY ChangedDate DESC
>
>When i try this, i am getting
>
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '1'.
>
>I am using SPT , Any Idea ?

What version of SQL Server are you using? I am using 7.0, which supports TOP n, but I think I remember reading that 6.x and earlier do not.