Hello,
A column, say CUST_RESPONSE, in this table is created as char
(100). The data stored in this column may be 100
or less than that. The data stored in this field will look like as
mentioned in bold below.

CUST_RESPONSE - Brochure reached customer. Customer requested
to arrange a meeting with bank staff within a month.

First field contains first 60 characters and second field contains
the remaining characters.

For example, if the length of the data is 80, then first field is
the first 60 characters and the remaining 20 characters in
second field.

While breaking the actual data, I also should ensure that the words
are not broken and remain intact.

For example, if you break the above text (in bold) till the 60th
character, then the word meeting would be disturbed as m is the 60th
character. In this case,
we need to show "Brochure reached customer. Customer requested to
arrange a" in field and "meeting with bank staff within a
month." in the second field.

How do we do it.

Regards,
Shiva