Page 1 of 1

Can't solve Advanced SQL Syntax

Posted: Sun Apr 10, 2011 2:58 am
by bnava
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:
Image

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