How to insert email id in table

[Mintoo kumar]

Hi All,

I have one query how to write to query to insert email id of form like
amit.d'[email protected].

Can anybody have any clue.

____________________
Mintoo
SCJP 1.4
____________________

[Jan Cumps]

Yes. You can type the ' after the d twice: amit.d''[email protected]
If you use java to insert the values, please use a PreparedStatement.

Regards, Jan

[Campbell Ritchie]

Probably worth using a regular expression to validate the e-mail address first. When I Googled, this appeared. It doesn't give all the answers, but is probably well worth the read!