# 1039 SQL and Filter SUBSTRING Function Returning Incorrect Results

---

Manual indicates:

SUBSTRING(column_reference or string constant FROM start_index [FOR length])

I current have to put substring(MyVar from 3 for 3) to get one character at position three. If I put from 3 for 1, I get a blank.