convert a substr to uppercase
Hey there, I am appending the first 3 letters of brand name with my product SKU. but I would like to make sure that the first 3 letters of the brand name are in uppercase. how can I do this:
I have tried adding in 'ucwords' after 'substr(' but that dont work.
$InsertQuery->bindColumn("ProductSKU", "s", "".substr(((isset($_POST["productbrand"]))?$_POST["productbrand"]:""), 0, 3) ."".((isset($_POST["productsku"]))?$_POST["productsku"]:"") ."", "WA_DEFAULT");
Chris