Hot to insert both values together?

[Miguel Dias Moura]

Hello,

i am inserting some form values in a database. Two of this values are as
follows:

<Parameter Name="@FirstName" Value='<%# IIf(FirstName.SelectedItem.Value <>
"", FirstName.SelectedItem.Value, "") %>' Type="WChar" />
<Parameter Name="@LastName" Value='<%# IIf(LastName.SelectedItem.Value <>
"", LastName.SelectedItem.Value, "") %>' Type="WChar" />

What i want is to insert both FirstName and LastName in the same database
field.

Something like inserting FirstName + " " + LastName in the database field
@FullName.

How can i do this?

Thank You,
Miguel

P.S: using ASP.Net / VB / Microsoft Access

[Mark Fitzpatrick]

Miguel,
This may be best to do in the actual SQL code. You can set a field
value in the insert statement to be equal to @FirstName + ' ' + @LastName

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hello,

i am inserting some form values in a database. Two of this values are as
follows:

<Parameter Name="@FirstName" Value='<%# IIf(FirstName.SelectedItem.Value <> "", FirstName.SelectedItem.Value, "") %>' Type="WChar" />
<Parameter Name="@LastName" Value='<%# IIf(LastName.SelectedItem.Value <>
"", LastName.SelectedItem.Value, "") %>' Type="WChar" />

What i want is to insert both FirstName and LastName in the same database
field.

Something like inserting FirstName + " " + LastName in the database field
@FullName.

How can i do this?

Thank You,
Miguel

P.S: using ASP.Net / VB / Microsoft Access