Re: Data type char and text incompatible

Hi,
Did we find a solution to this?
With SQL Server Express, I get this error with the following SQL, simplified
select myfield from mytable where myfield = :pmyfield
given myfield is varchar(20)
and pmyfield is ftstring

Thanks
David


"fiaola" <fiaola@xxxxxxxxx> wrote in message
news:45e63337@xxxxxxxxxxxxxxxxxxxxxxxxx
I keep getting this error message "data types char and text are
incompatible in the equal operator.

Can someone enlighten me on how to resolve this problem. I'm sure its
quite simple, but just can't get my hand on the fix.

Thanks in advance.



.

Relevant Pages

  • Re: SSIS and Cannot insert the value NULL into column myField
    ... Allan Mitchell ... I have to copy data from one sql server table into another sql server ... column does not allow nulls. ... 'myField' in the destination table which really does not allow NULLs ...
    (microsoft.public.sqlserver.dts)
  • Re: Is faster use MIN function or TOP 1 with ORDER BY
    ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... > SELECT TOP 1 MYFIELD FROM MYTABLE ORDER BY MYFIELD ...
    (microsoft.public.sqlserver.programming)
  • Re: Copying Data from Access to SQL Server
    ... I can export the data from Access, copy it via FTP, then import it into SQL Server. ... That's a good, clean technique, but is extremely slow (about 10x slower than the file copy technique). ... dbo.mytable (myfield) ...
    (comp.databases.ms-access)
  • SSIS and Cannot insert the value NULL into column myField
    ... I have to copy data from one sql server table into another sql server ... I'm using SSIS for the first time... ... column does not allow nulls. ... This sounds really reasonable to me, because there is a field 'myField' ...
    (microsoft.public.sqlserver.dts)