![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Sun, Apr 8 2007 7:20 PM | Permanent Link |
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.? |
Mon, Apr 9 2007 7:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Mon, Apr 9 2007 7:37 PM | Permanent Link |
Michael | 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 |
Mon, Apr 9 2007 8:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Fri, Apr 13 2007 9:12 PM | Permanent Link |
Michael | I sent a swf file to you
|
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |