Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

LEN Returns the length of a string as an integer

3> 4> DECLARE @LEN_STRING varchar(100) 5> SET @LEN_STRING = "www.rntsoft.com" 6> 7> SELECT LEN(@LEN_STRING) 8> GO -----------          14 (1 rows affected)