On 04.10.2018 at 10:34, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> Hi,
> I am trying to get below stuff using SQL only.
> 1. If I have any statement like "World is good enough to enjoy..." then in I
> need to get SQL out put as"WorlD IS GooD EnougH TO EnjoY..." that is firs
These type of string operations are better done at the client side in C#,
VB.NET, Java, or any other high level language. Using any variant of SQL to do
such tasks would be quite onerous.
However, if this is a homework assignment and you need some assistance, please
let me know and I would
It's not homework assignment. I always try to play with SQL and just got an
idea to deal with such tasks, as there are always new requirements come for
displaying report with different formats.
Mostly I try to get the output from SQL execution part itself rather than
stored procedure or from UI
On 4-10-2018 10:34, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> I am trying to get below stuff using SQL only.
>
> 1. If I have any statement like "World is good enough to enjoy..." then
> in I need to get SQL out put as
> "WorlD IS GooD EnougH TO EnjoY..." that is first an
Hi Vishal!
SQL puzzles can be interesting, so I decided to have a go at your quest.
with recursive tmp ( MyInput ) as
( select cast( :InputString as Varchar( 500 ) ) from rdb$database ),
WordLetter ( ThisChar, RestInput, WordPos, CharPos ) as
( select substring( lower( MyInput ) from 1 for 1 ),