Databases Reporting with SQL Working with Text Creating Excerpts

Andy McMurry
Andy McMurry
4,276 Points

I think my code is right but keep getting an error message

I've tried my code on this challenge in SQL playground and it works, but I keep getting the error message that there's something wrong with my code.

SELECT SUBSTR(first_name 1,1) AS "initial",last_name FROM customers;

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 47,519 Points

You are missing a comma after first_name, It should be:

SUBSTR(first_name, 1,1)

Andy McMurry
Andy McMurry
4,276 Points

Thank you!!! This was driving me nuts!!