basically the logic of this code is what I need into the format of an sql select query:

declare @start as int;

declare @end as int;

declare @entries as int;

set @start = 1;

set...

Hey, I did find a couple of steps from some coworkers. Basically I found that I could use the format:

SELECT (substr(#prompt('List', 'String')#,1,instr(#prompt('List','String')#,', ')-1)) Asset FROM Dual Union

SELECT (upper(#prompt('List', 'String')#)...

It's just hard to find someone with the knowledge in both systems. But thank you both for trying.

@ Ninja's_RGR'us

I am confident it will work if your putting into an SQL processing program. I am also confident it will work for me if I do the same....

Thanks, but that doesn't work for me which is why I asked for help. I was hoping to find a person that knows SQL, Cognos, and willing to help. I...

I guess it's too hard to do. 🙁