1 Reply Latest reply on Feb 8, 2018 5:30 PM by NadimG

    Week 4 Task 1 #21, having a problem with the auto-generated userid field.  The script as I have it now is:


      insert into my_employee values (&empid, '&last', '&first', concat(lower(substring('first', 1, 1)), lower(substring('last', 1, 7))), &sal);

      The error I'm getting is "Substring": invalid identifier.  A little help please?  Thanks!