Trying to make my mysql output upper-case?

[lukeurtnowski]

I have a dynamic table (MySQL), how do i get all the columns of output converted to uppercase (I tried UPPER() and UCASE(), but neither one worked)😕

[diego25]

They should both work...can you post some code?

Please note that UPPER and UCASE are MySQL functions, not PHP functions...

Diego

[dalecosp]

In PHP:

$foo="some word";
$foo=strtoupper($foo);
echo $foo;
//output is "SOME WORD"

[lukeurtnowski]

thanks