String Function Help

[TheTucsonKid]

Hello All,

I need help in finding the right string function to perform a task. I am trying to break the contents of a varchar2 4000 field into smaller, 65 character chunks so it will be compatible with an older system. I need to test for a blank space at character position 65,64,63 and so on until a blank is found. Every 65 character chunk will get a sequence number to keep track of the order. Does anyone know of a function that will return the contents of a specific character position?

Any advice will help greatly. Thanks

Brett

 

[LKBrwnDBA]

Try:

SUBSTR(<string>,<start position>[,<length>])



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[TheTucsonKid]

That did it. Thanks for the speedy response.

Brett