Max length allowed for RETURN in a function

• _UB

  SSCrazy

  Points: 2987

  More actions

  August 5, 2008 at 5:16 pm

  #196503

  ALTER FUNCTION dbo.Translate (@Source VARCHAR(8000))

  RETURNS VARCHAR(8000)

  AS

  BEGIN

  -- do something

  -- do more

  --

  -- at last

  RETURN REPLICATE('a', 8000)

  END

  /*

  TESTING:

  SELECT dbo.Translate('blah')

  Output:

  aaaaaaaaaa..... 256 times

  */

  Output value has length of 256, even though REPLICATE 8000 is used..... why? I am I missing something. Please help.

  SqlTimes Blog on Sql Server

• _UB

  SSCrazy

  Points: 2987

  More actions

  August 5, 2008 at 6:09 pm

  #853563

  oops..!!

  The problem is not with the function, but with my SSMS. The default value for column length is set to 256.

  SqlTimes Blog on Sql Server