i have a table in which i need to update the column "comments" based on the maximum legth by ID.
i need that in column "Comments" to write the maximul legth coment by ID.
in table 1 is the intiial data and table 2 has the data as i want to have:
i tried to use max(length(Comments)) or max(datalength(Comments)) but it gives me the number length instead of the comments itself. I also tried max(comments) but it gives me the forst commet that it sees for the speciffic ID.
maybe someone can give me an idea.