Appending text to sql data

• rasadee

  SSC Journeyman

  Points: 79

  More actions

  March 6, 2008 at 12:53 pm

  #379071

  Hi,

  I have a query that returns page names, for example, test.aspx.

  How do I append "href" to the "test.aspx" returned from the query?

  Thank you for all the help.

• TraderSam

  SSCrazy

  Points: 2931

  More actions

  March 6, 2008 at 1:25 pm

  #786330

  In your SELECT, try this...

  select 'href' + columnname

  from sometable

  If it was easy, everybody would be doing it!;)

• sqld-_-ba

  SSCarpal Tunnel

  Points: 4365

  More actions

  March 6, 2008 at 1:29 pm

  #786331

  do you want to append href inside the file test.aspx?

  declare @var char(10)

  select @var=name from Filenames where name like '%.aspx' --sample query

  -- now @var holds the value 'test.aspx'

  -- this does not work if the query returns more than one value

  declare @qry char(100)

  set @qry = 'echo "href" >> '+@var

  xp_cmdshell @qry