SQL query related...

Thankyou for your help.

I have tried to implement it as it is and it works.

But When I try to do it on my actual data table it gives me error (Missing operand after operator).

Actually my column names are a bit complicated such as:

ABC$B/XYZ/04-45$ABC-XYZ$ABC XYZ (its a column name)

so when I apply it:

DataRow[] maxRow = dt.Select("ABC$B/XYZ/04-45$ABC-XYZ$ABC XYZ = MAX(ABC$B/XYZ/04-45$ABC-XYZ$ABC XYZ)");

It raises the exception (Missing operand after operator).

Please guide me how to correct this error.

Also is it possible that I can give column index instead of column name in the above select query?

Hope to see your reply soon.

Regards,

Naureen.