Can't solve Advanced SQL Syntax
Posted: Sun Apr 10, 2011 2:58 am
Hello guys, I'm trying to solve my hometask . I tried in many different ways to solve the task related with Advanced SQL Syntax. Please check the pic below:

The Quiz is asking for make location appear in all uppercase letters, the character associated with a given ASCII value and the table is people.
I tried the last one in this way:
SELECT CONCAT(name,'is from',strtoupper(location),' The ASCII character of the number ',number,' is ',ASCII(number)) FROM `people` WHERE 1
but it doesn't work. Can someone help me?
Thanks

The Quiz is asking for make location appear in all uppercase letters, the character associated with a given ASCII value and the table is people.
I tried the last one in this way:
SELECT CONCAT(name,'is from',strtoupper(location),' The ASCII character of the number ',number,' is ',ASCII(number)) FROM `people` WHERE 1
but it doesn't work. Can someone help me?
Thanks