RE: Combine 2 text values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ibrahim Shameeque (IbrahimShameeque_at_discussions.microsoft.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 01:49:02 -0700

Hi
You cannot concatenate text datatype 

-- 
Ibrahim
"simon" wrote:
> I have SP:
> 
> CREATE PROCEDURE sp_Upload
> @idOrder varchar(10),
> @result text
> AS
> 
> UPDATE t_narocilnica SET description=@result+description WHERE ID=@idOrder
> 
> Description is text field in table t_narocilnica.
> 
> I get an error message: error 403: invalid operator for data type. Operator
> equals add, type equals text.
> 
> What is wrong?
> 
> Simon
> 
> 
> 
>

Relevant Pages

  • Combine 2 text values
    ... I get an error message: error 403: invalid operator for data type. ... equals add, type equals text. ...
    (microsoft.public.sqlserver.programming)
  • Re: Declaration problem
    ... x is not overflowing, the result of your formula is overflowing. ... data type of a formula result. ... can't calculate x*30000 where x is an int>1. ... Simon Murphy ...
    (microsoft.public.excel.programming)
  • Re: VBA code false "rst.FindFist strSearch"
    ... "Simon" wrote in message: ... strUser has also a numeric value. ... The error message is "Data type mismatch in criteria expression". ...
    (comp.databases.ms-access)
  • Re: Japanese words
    ... but the most obvious data type for Japanese in MSSQL ... I have successfully used the MS JDBC driver for SQL server to select/insert ... Chinese data from MSSQL server. ... varchar, as Simon said. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Japanese words
    ... but the most obvious data type for Japanese in MSSQL ... I have successfully used the MS JDBC driver for SQL server to select/insert ... Chinese data from MSSQL server. ... varchar, as Simon said. ...
    (comp.lang.java.databases)