Not upper, not lower, but a bit of both? 1

[kupe]

Is there a sister function upper() and lower() - or a way to - to have text appear with the first capitalised and the rest lc, please, experts?

 

[TonyGroves]

You could try using both:
[tt]
CONCAT(
UPPER(SUBSTRING(fld1,1,1)),
LOWER(SUBSTRING(fld1,2))
)
[/tt]

 

[kupe]

Cheers, Tony, much obliged.

 

[ericbrunson]

MaxDB has "INITCAP()" like Oracle, but not vanilla MySQL.

 

[kupe]

Yes, it's a pity, Eric, thanks.

 

[kupe]

Hi Tony

I tried that last night, but it returned everything in lc. I'm sure there's a function I've often used in Access (can't recall it for the moment though). Odd there's not something similar in amazing (with respects to Eric Brunson)mysql. Cheers
paul

 

[TonyGroves]

That should work OK. It works for me, anyway. Are you sure you typed it as shown?

 

[kupe]

As they say, sure I'm sure, but I will try it again tonight if you feel that confident. Because I use the command prompt mostly, it was all on one long, nested line. But mysql responded to it. As I say, everything in lc, though. Cheers