>Thanks Naomi, I'm not so advanced in SQl , but I will try.
>
>C.B.
If you tell us the type of your PK and what type of the field you want to find maximum, someone would be able to help with the SQL I wrote. I think it could be done with CAST() function in SQL Server, but I'm not sure myself.
If it's not broken, fix it until it is.
My Blog