Thanx for the info .

Bottom line is always declare the size!!!!!

Hey Frank... I think we all used words we didn't mean at one time or another...

Hey we all gotta to learn that someday... and last Friday was my day .

You can always run this query to update the data

Update dbo.YourTable set YourColumn = UPPER(YourColumn)

then I would put an on insert/update and run the same query for that column.

Sounds good to me .

I've never had to use sp_executesql, so I wouldn't be of much help here .

That's why I'm using a "short" example.

You don't need a cursor to do this, check this out :

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items...

Hey govinn... I ran the script and posted the results. I don't know about any other version than 2000 and I didn't check the books online.

Looks like somebody misunderstood the question...

looks like it's me .

Declare @m as varchar

select datalength(@m)

--null

set @m=''

Select top 1000 @m = @m + '12345678' from dbo.SysColumns

Select datalength(@m), @m

--1, 1

set @m = '1234'

select @m

--1

Any variable is null right after its declaration. ...

A few things come to mind but those are all guesses. So if I'm wrong I'd like if you could post the whole code for all the objects that...

I learned 75% of what I know here... gotta give something back someday.

Wow, nice to know. Thanx for the info.

Or forgetting to say all the words .