LEN and DATALENGTH

• JMI

  SSChampion

  Points: 11831

  More actions

  September 23, 2003 at 6:58 am

  #82264

  Do you mean

  I should use DATALENGTH instead

  of LEN?

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  September 23, 2003 at 7:30 am

  #475406

  Not sure what you are referring to, but it depends on what you want. DATELENGTH returns the number of bytes, where as LEN returns the number of characters.

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  September 23, 2003 at 11:51 am

  #475469

  It relates to this topic...

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16447&FORUM_ID=8&CAT_ID=1&Topic_Title=CREATE+RULE&Forum_Title=T%2DSQL

  Riga1966 just started a new thread instead of responding to the original one.

  -SQLBill