Sunday, August 14, 2011

3. Research the Len, InStr & Mid functions.


Len Function


Returns the number of characters of the specified string expression, excluding trailing blanks
Syntax    LEN ( string_expression )
               
Arguments
string_expression 
string_expression can be a constant, variable, or column of either character or binary data

Return Types
bigint if expression is of the varchar(max), nvarchar(max) or varbinary(max) data types; otherwise, int.

No comments:

Post a Comment