Re: SQL Statement Problem : Separate long varchar into word seqments
by steve <rog11228@[EMAIL PROTECTED]
>
May 14, 2008 at 03:23 AM
Here is a relatively simple iterative solution to this problem:
'Splitting a string into fixed sized word segments'
http://beyondsql.blogspot.com/2008/05/dataphor-splitting-string-into-fixed.html
A relational system greatly simplifies problems like this :-)
best,
steve
www.beyondsql.blogspot.com
On May 9, 12:45 pm, jephperro <jeff.perrea...@[EMAIL PROTECTED]
> wrote:
> Hi there,
>
> I'm having a really tough time with a SQL statement and I am wondering
> if someone is able to help out or point me in the right direction.
>
> I have a table of names which can be very long. These names get
> printed on envelopes. The problem is the envelope can only hold 35
> characters per line. I have to divide into 4 lines at most.
>
