SQL Server Develepment

• sabeer

  Ten Centuries

  Points: 1377

  More actions

  March 12, 2009 at 4:45 am

  #93288

  DECLARE @myString varchar

  SET @myString = 'TESTING'

  SELECT LEN(@myString)

  :P:P:P:P:P:P:P
  Thanks,
  Sabeer.M

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 12, 2009 at 4:49 am

  #958175

  varchar with no length means varchar(1), so you'll get 1 as result.

  Gianluca

  -- Gianluca Sartori