I'll throw in my proper case function just for laughs...

ALTER FUNCTION [cf_ProperCase] (@String varchar(MAX))

RETURNS varchar(MAX)

AS BEGIN

DECLARE @ReturnString varchar(max),

@i int;

SET @ReturnString = ''

SET @i = 1

WHILE @i <= LEN(@String)

BEGIN

SET @ReturnString = @ReturnString +

(CASE WHEN (@i = 1 OR SUBSTRING(@String, @i - 1, 1) = ' ')

THEN UPPER(SUBSTRING(@String, @i, 1))

ELSE LOWER(SUBSTRING(@String, @i, 1))

END)

SET @i = @i + 1

END

RETURN @ReturnString

END

Very brute-force, but it works.

Ron Moses