Jeff..............Thanks for the help. No problem on the delay. I'm really new to writing sql and use these forums to help solve the things I'm trying to do. I'm an accountant by trade but we are moving into more of a report writing role. I had a 2 day class in sql; which was pretty basic. Very small tables and only a few simple joins. The tables I'm working with are much larger and there are many more to work with. After trying a number of different things, this is what I came up with. Not sure how good this is but it seems to do what I was looking to do in the SELECT statement

substr(note_txt_ln, 27,(cast(instr(note_txt_ln, 'to') as integer) - 28) ) as Status_FROM,

substr(note_txt_ln, (cast(instr(note_txt_ln, 'to') as integer) +4), (cast(length (note_txt_ln) as integer) - (cast(instr(note_txt_ln, 'to') as integer) +4) )) as Status_TO,

Thanks again for taking the time to reply.......