Icon View Incident Report

Serious Serious
Reported By: Donat Herbert
Reported On: 2/16/2002
For: Version 3.05 Build 1
# 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.

Resolution Resolution
Fixed Problem on 2/27/2002 in version 3.07 build 1