Yes, thank you very much. Perfect.
----- Original Message -----
From: "Raster, Tim" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Friday, August 01, 2003 5:09 PM
Subject: RE: UDF insert space every 10 charaters
> Something like this?
>
>
> -- - - - - - - - -
>
> CREATE FUNCTION InsertSpaces (@GivenString varchar(8000), @N int = 10,
> @InsertChar varchar(1) = ' ')
> RETURNS varchar(8000) AS
> BEGIN
>
> declare @S varchar(8000), @L int, @I int
>
> set @S = @GivenString -- Temporary string to hold our modified string
> set @L = len(@S) -- Holds length so we don't have go call
> len() a lot
> set @I = @N -- Temp Integer
> while @I < @L
> begin
> set @S = left(@S, @I) + @InsertChar + right(@S, @L - @I)
> set @L = @L + 1 -- Our temp string is increased by a
> space now
> set @I = @I + @N + 1 -- Our position pointer advances
> the num of chars + 1 for the space
> end
> return @S
> END
>
> -- - - - - - - - -
>
> Then call it with something like this:
>
> print dbo.InsertSpaces ('ThisIsATestOfTheEmergencyBroadcastSystem.',10,'
> ')
>
> output: ThisIsATes tOfTheEmer gencyBroad castSystem .
>
> Or you can do something like:
>
> Update MyTable Set MyField = dbo.InsertSpaces (MyField,10,' ')
>
>
>
> -----Original Message-----
> From: David Brown [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 01, 2003 15:54
> To: SQL
> Subject: UDF insert space every 10 charaters
>
> I would like some help on creating a udf that would insert a space every
> 10
> charaters. Some of our columns store long text that does not have
> spaces.
> One "word" could be 20 to 40 charaters long. That does not wrap well in
> html. Any suggestions?
>
> I could do this in cold fusion, but it would be very slow.
>
> David
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
