>Hi everyone,
>
>what data type accept any type of data in SQL table?
>I need to store a email, in to a field in the SQL table, the data type is right now nvarchar(4000). This dose not eccept some characters in the email and crash.
>What is the best solution for this?
>Can someone help me with this?
>
>Thanks.
In addition to James's suggestion, you could try TEXT.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao