2. ASPRunnerPro General questions
  3. concatenate field
This topic is locked

concatenate field

 		4/29/2008 9:52:33 AM
ASPRunnerPro General questions
E
 enetsat author

Hello for all !!

Someone can help-me ?

I wanna concatenate the some fields

How to make it in ASPRunner PRO
Im use the
SELECT field1 + 'Field2 ' + Field3 + '/' + Field4

FROM TABLE1
More no function .. he show-me Expr1000
Thanks for all
J
 		Jane 4/29/2008

Hi,
edit your SQL query on the Edit SQL query tab.

Here is a sample:

SELECT field1 + 'Field2 ' + Field3 + '/' + Field4 as [anotherfield]

FROM TABLE1
E
 		enetsat author 4/29/2008

Hi,

edit your SQL query on the Edit SQL query tab.

Here is a sample:


Tahnks for your help .. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28722&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28722&image=2&table=forumreplies' class='bbc_emoticon' alt=':lol:' />