Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Hyderabad, India

    Unanswered: Using Space(n) function

    Here I am using Space() function as below:

    select space(51) as Name, SEQ into #Temp from Member.

    In the above query it is inserting space(1) instead of 51 spaces.

    Can any one help me out in the same?

    Thanks in advance!!
    -PavanKumar M Reddy

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    That is because the target table is created with a varchar column
    instead use:
    select convert(char(50),'') as Name, SEQ into #Temp from Member

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts