max function

, ,
1

Hi all,
i use the max function to get the current max ID of the user. I defined the ID as String in database.
The function returns alway 9 although the max ID is at 10. Why? Maybe the ID should be defined as numeric value?

Thank you in advance.

Chacha

2

I have tested the function with integer value. It works well now.