This old function I made may help as it demonstrates the concepts of looping with SQL (without a yucky cursor!).

CREATE function [dbo].[fn_Is_Uppercase]
(@string varchar(1000))
returns bit...

This (http://msdn.microsoft.com/en-us/library/ms189461.aspx) may correct the issue if implemented correctly, and at the same time eliminate the need of your functions.

To correct the function and...

Peter,

It seemed his/her question was pretty straight forward and geared towards flat files and text manipulation. You earlier replied with "I do not understand what this has to do with...

I think you should look into using DTS or SSIS (depending on SQL version) to bring the information in, then export it out.

This is a 5 minute job if you're familiar with DTS or SSIS.