Creating new ms sql field to link records across table for easy user recall in vbscript

I'm a newbie with vbscript and i need help creating a concatenated field joining transID, Date and userID in a hidden form field that ties records together across tables giving user ability to save and come back. Because transID is an incremented field transID in each table differ. Once this field is created it will then be dumped into a session variable to be used in subsequent record creation. Any suggestions how to go about this.
GMMC_manAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Select those combined value as a new value and try
Try using like this:

select transID, Date, userID, transID + Date + userID concatvalue
from urtable

Use the combined value for your comparisons or manipulations
0
 
GMMC_manAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.