itemprop="text">
Does any one know the equivalent to
this TSQL in MySQL parlance?
I am
trying to capitalize the first letter of each
entry.
UPDATE tb_Company SET
CompanyIndustry = UPPER(LEFT(CompanyIndustry, 1))
+ SUBSTRING(CompanyIndustry,
2, LEN(CompanyIndustry))
It's almost the same, you just have to change
to use the CONCAT() function instead of the + operator
:
UPDATE tb_Company
SET
CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)),
SUBSTRING(CompanyIndustry,
2));
This would turn
hello
to Hello
,
wOrLd
to WOrLd
,
BLABLA
to BLABLA
, etc. If you want to
upper-case the first letter and lower-case the other, you just have to use LCASE
function :
UPDATE
tb_Company
SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)),
LCASE(SUBSTRING(CompanyIndustry,
2)));
Note
that UPPER and UCASE do the same thing.
No comments:
Post a Comment