Concatenating two form fields into one...

[Mike]

I have a form that I collect information about a
new employee on.

Two of the fields are 'FirstName' and 'LastName'.
I need to concatenate them into one field and
add an extra string to make their e-mail address.

The problem is that I only need the first character
of their First Name, not the entire name.

So I need to take the name Fred Smith and
write (e-mail address removed) to my dbase.

I have used the following line to concatenate two
fields to form the address but we have changed
our naming standard:

request.form("FirstName") & "." & request.form("LastName") & "@email.com"

which returned (e-mail address removed)

Any help would be appreciated.

Mikeal

 

[Steve Grosz]

I know that with VB there is a Left$ function, not sure what you're using.
But in VB it would be Left$("FirstName",1) for just the 1st letter of the
1st name.

Steve

 

[Ken Ford - PVII Support]

Left(Request.Form("FirstName"), 1) & "." & Request.Form("LastName") &
"@email.com"