"Robert Bravery" <m*@u.com> wrote in message
news:eBAeJKrLGHA.536@TK2MSFTNGP09.phx.gbl...
> HI all,
>
> When trying to insert text into a char or varchar column that contains an
> apostrophe ' I get an error message
> "the value you entered is not consistant with the datatype or length of
the
> colum"
> I know the length is not a problem, and I'm sure that ' is a char value.
> How do I deal with this.
> I need to import text type date, not long less thatn 100 char, from anothe
> database into an sql table
>
> Thanks
> Robert
>
>