Anybody have a way for uppercasing a field defined as a text datatype?

I tried making a UDF to parse 8000 characters at a time and use the
UPPER function on each substring, which worked, but with no way to
declare and return a text variable within a UDF, I didn't have a way to
reassemble the converted data and send it back.

MS Sql Server LazyDBA home page