SQL upper/lower + substring not working well

I have a table with a column named "name" between other columns. I was making experiments with sql functions and I don't know why this doesn't work. When I run this code:I have a table with a column named "name" betwe