Query giving wrong answer

Question

I am using mysql I want first letter of firstname capital and remaining characters in lower case the query i am using is

select  UPPER(LEFT(FirstName,1))+LOWER(SUBSTRING(FirstName,2,LENGTH(FirstName))) FirstName from colliers;

this gives answer 0, but it works perfectly in SQL server ..

http://stackoverflow.com/questions/4263272/capitalize-first-letter-mysql — Abhik Chakraborty, Sep 24 '14 at 15:17

score 1 · Answer 1 · answered Sep 24 '14 at 15:20

1

You have to use CONCAT(), instead of +

SELECT CONCAT(UPPER(LEFT(FirstName,1)),LOWER(SUBSTRING(FirstName,2,LENGTH(FirstName)))) FirstName from colliers

answered Sep 24 '14 at 15:20

Arun

941
6
13

score 1 · Accepted Answer · answered Sep 24 '14 at 15:22

You have to use concat(). "Plus sign" concatenation doesn't work in MySQL. You will probably end up with something like this :

select CONCAT(UPPER(LEFT(FirstName,1)), LOWER(SUBSTRING(FirstName,2,LENGTH(FirstName)))) FirstName from colliers;

By the way you don't need LENGTH(FirstName) in the SUBSTRING() function call. When the third parameter is omitted SUBSTRING() assume you want the rest of the string.

score 0 · Answer 3 · answered Sep 24 '14 at 18:20

0

Just one more way to solve the problem!

I would use concat(), ucase()/upper(), lcase()/lower(), mid()/substring()

SELECT CONCAT (
        upper(mid(Firstname, 1, 1))
        ,lower(mid(Firstname, 2))
        )
FROM colliers;

answered Sep 24 '14 at 18:20

Logan

1,331
3
18
41

Query giving wrong answer

3 Answers3