>>>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.

Nop, i am using 7.0