Adding Server Prefix to string of field names

• GrassHopper

  SSCarpal Tunnel

  Points: 4473

  More actions

  May 21, 2014 at 5:54 am

  #150155

  I am doing some dynamic programming and I have a list of field names that I am passing to a sql procedure from ms access. I want to add the table name as a prefix to the field names, how can i do this?

  string of field names is :

  'field1,field2,field3,field4,field5'

  I want to have:

  'MyTable.field1,MyTable.field2,MyTable.field3,MyTable.field4.MyTable.field5'

  Is there a function I can use to do this?

• GrassHopper

  SSCarpal Tunnel

  Points: 4473

  More actions

  May 21, 2014 at 6:59 am

  #1715331

  I found the answer to my own question:

  @MyTable + '.' + REPLACE(@MyFields,',',',' + @MyTable + '.')