Using sql Server 2008 Express How to use "@" inserting an email add. in a record

Question

Hi, I am getting errors while trying to insert an email address in a record. I think they are related to the @ symbol.

Is there something special I need to do with the @ symbol?

Answer 1

If you are using string concatenation to do it then you will get errors... the ampersand is used to indicate a parameter. Can you post more info (ie. sample code, errors, programming language)?

Answer 2

The variable you store the string into can be preceded by an @ to take it "literally" or "verbatim"

such as

String myEmail;

myEmail = @"[email protected]";

...

Although I must admit, I've only needed the literal when dealing with file system paths, not email addresses.