Select SubString(Subject From 4 For Length(Subject)-7) AS Patients, Notes from WaitList

The length function in this statment is not working seems to e a bug.?

Michael,

<< Select SubString(Subject From 4 For Length(Subject)-7) AS Patients, Notes
from WaitList

The length function in this statment is not working seems to e a bug.? >>

Per email:

What are you trying to accomplish with your SQL statement ?  The LENGTH
function works fine, so I assume the issue is that you are expecting a
different result than what you are getting from the SUBSTRING function.  By
the way that you constructed your SQL statement, it appears that you might
expect that the FOR parameter to the SUBSTRING function acts like a right
position, and that's not the case.  The FOR parameter represents the number
of characters to extract, starting from the FROM position.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

This is a project that I ported over to EDB from DBIsam it works fine in DBIsam but not in EDB.


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Michael,

<< Select SubString(Subject From 4 For Length(Subject)-7) AS Patients, Notes
from WaitList

The length function in this statment is not working seems to e a bug.? >>

Per email:

What are you trying to accomplish with your SQL statement ?  The LENGTH
function works fine, so I assume the issue is that you are expecting a
different result than what you are getting from the SUBSTRING function.  By
the way that you constructed your SQL statement, it appears that you might
expect that the FOR parameter to the SUBSTRING function acts like a right
position, and that's not the case.  The FOR parameter represents the number
of characters to extract, starting from the FROM position.

Tim Young
Elevate Software
www.elevatesoft.com

Michael,

<< This is a project that I ported over to EDB from DBIsam it works fine in
DBIsam but not in EDB. >>

Could you please send me an example of what you're seeing (with the table
and catalog) ?  I'm not seeing any improper behavior here with EDB and the
LENGTH or SUBSTRING functions.

--
Tim Young
Elevate Software
www.elevatesoft.com

I sent a swf file to you