Can't solve Advanced SQL Syntax

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
bnava
Forum Newbie
Posts: 1
Joined: Sun Apr 10, 2011 2:37 am

Can't solve Advanced SQL Syntax

Post 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
Post Reply