Re: SQL Statement Problem : Separate long varchar into word seqments 35 chars long

jephperro (jeff.perreault@[EMAIL PROTECTED]
) writes:
> 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.
> 
> So I need to separate these long varchars into segments, no longer
> than 35 characters but preserving whole words.
 
T-SQL is definitely a poor choice for this sort of job. If you are on
SQL 2005, write a function in C# or VB .Net for the task. Probably
you should use the RegEx cl*****.

If you are on SQL 2000, try to find solutions client-side.


-- 
Erland Sommarskog, SQL Server MVP, esquel@[EMAIL PROTECTED]
 Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx