It is possible to do what you are asking. My concern with it would be why would you want to do this in your database? I see poor database designs all the time where information is duplicated and concatenated and stored in multiple tables.
To do what you're asking, why not do the string manipulation in your VB code and then pass that variable as a parameter in your insert statement. I.E. (pseudocode) Dim strConcat as String strConcat = Name & " " & strMessage Dim sql as String = Insert into tableName(concatItem) value (strConcat) On Aug 5, 7:41 am, Jeena Ajiesh <[email protected]> wrote: > Hi all, > > Can we concatenate a string value with the value from database? > > For Eg: I have to get the names from database and concatenate with a textbox > value and store it in database again in different table. > > What i have tried to do is: > > Dim strSql As String = " Insert into > Mess(UserName,Number,Title,Lan,Txt,Status) Select '" & strUserName & "',* > NNub*,'" & strTitle & "','" & strLan & "',*Name* '" & strMessage.Replace(" > '", "''") & "','" & StrStatus & "' From Group Where GroupName='" & > dllgroup.SelectedItem.Text & "' and UserName='" & strUserName & "'" > > Here im taking the NNub from the database directly.What i need is i have to > concatenate Name & strMessage. > > So that it will save in database; if strmessage is "HI" > > Tom HI > > Jerry HI > > Like this. > > Is it possible. Because i tried my level best, pls help me if anyone can > advise on this... > > -- > **************** > Thanks & Regards, > Jeena Ajiesh
