Using Oracle 9i SQL (no PL/SQL due to gui front end)
I have 3 columns. System, franchise, servcode. In servcode column it can be up to 1200 char wide. Service codes displayed set up like this: AA BB CC DD EE FF etc. May be one 2char code wide, or 300 2char codes wide with a space in between. Need to figure out how to display system, franchise, and then convert the servcode column into multiple rows, as many rows as there are codes. Ive tried a replace command that wherever there is the space, that a CHR(10) (carriage return) is inserted. That got me multiple rows of code, but in my gui (Forest & Trees) it still shows as one row. Ex:
system franchise servcode
8888 10 AA
                         BB
                         CC
                         DD etc
I really need the system & franchise to be displayed on each line,and the codes displayed along side them. Have never run across a problem like this before. any ideas would be greatly appreciated. Thanks much.

Hi,

  Convert to an array using

dim arrSrvCode
arrSrvCodes=split(srvcode," ")

 then, do your coding...

Did you try replacing SPACE with VBCrLf instead of CHR(10), did that help? Has this got anything to do with ASP? If so, can post that part of code so that to help you better.

Cheers!

_________________________
- Vijay G
Strive for Perfection