SETting @localvariable(s) within a CASE statement

• NadJ

  Ten Centuries

  Points: 1031

  More actions

  December 9, 2004 at 8:48 am

  #74811

  Can someone tell what I can do so that the bit in bold becomes a legal move! (Fails at SET)

  BEGIN

     declare @List  varchar(8000)

     declare @r int

     SELECT 

              @R_List = COALESCE(@List + CHAR(10), '') + 

     CASE

           WHEN (ACOM.FREQ_2 IS NULL)

           THEN

              SET @r = LEN(C_TYPE)

                 C_TYPE + SPACE(@r) + FREQ_1 + SPACE(@r) + C_NAME

  I need to adjust the spaces in the returned value of a function. The function itself contains a CASE statement though. Is there anything obvious that's wrong, or shall I offer some more of the query.

  Thanks again to all you wonderful folk

      

           

• NadJ

  Ten Centuries

  Points: 1031

  More actions

  December 9, 2004 at 8:59 am

  #533207

  We all have our embarrasing moments and I think this is one of them. A case of trying to hard?

  certainly.

  All I did in the end was:

   C_TYPE + SPACE(LEN(C_TYPE)).......