RE: Hello World?

That looks like it’s doing a substr based on the end value.

Here’s a curious question: what do you see when you sneak a peek at what the query is actually doing?

In case you’re not familiar with it, the installation of Toad comes complete with a SQL Tracker Utility (great tool).  You should be able to find it under Toad -> Tools in your menu selection.  In Toad 10.6.1.3 it’s called “SQL Tracker”.  Once it’s logging against your Toad session, run the query and take a look at the tracker results to see what was actually sent to the database.

Roger S.

________________________________
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.