the only difference is exactly that!
DATALENGTH(expression) is for text, ntext, and image columns and LEN(string)
is for varchar, char, number, etc.
DATALENGTH
Returns the number of bytes used to represent any expression.
Syntax
DATALENGTH ( expression )
Arguments
expression
Is an expression of any type.
LEN
Returns the number of characters, rather than the number of bytes, of
the given string expression, excluding trailing blanks.
Syntax
LEN ( string_expression )
Arguments
string_expression
Is the string expression to be evaluated.
BTC
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
