Get lenght of.....

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  February 25, 2008 at 6:29 am

  #187014

  Hello,

  Can anyone tell me how can i get the lenght of one column, for example if i've one column that is one varchar(500) but i've insert in this column data with 120 character what function can i use in SQL Server so that the output of the row size? (in character of corse)

  Thanks and regards,

  JMSM 😉

• dragos_sv

  Default port

  Points: 1478

  More actions

  February 25, 2008 at 6:40 am

  #781523

  if you need the number of characters of your_column, try len(your_column) or max(len(your_column)) if you want to determine the max across the table