Max and Min function on character/string data ?

[HWallays]

Is there a function that will allow me to select the min or max of a string value ? Have the impression it only works with numerical data but does not work with strings ( in sql I use it regularely for strings too)… 

When applying the min or max on strings it returns blanks 😉 

[kaushiknsolanki · Accepted solution]

Hi,

Try MinString and MaxString functions.

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

How is the string looks like? Can you post few rows for us

[HWallays]

thank you kaushiknsolanki. 

I was not aware there were actually specific minstring and maxstring functions. Indeed they work perfectly !