[dbo].[length_varchar]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@s	varchar(max)	max

CREATE FUNCTION [dbo].[length_varchar](@s varchar(max))
returns int
as
begin
return len(replace(@s, ' ', '.'))
end
GO