SQL Function

From: "Sean" <sklosky@xxxxxxxxx>
Date: 27 Apr 2006 16:43:39 -0700

hello everyone,

I created a function in MSSQL that builds an html coupon based upon the
coupon ident (more complex than that, but that's not where i'm having
problems!)

When the function builds the coupon, it returns the stream as
VarChar(8000)

I am calling this function in a sproc that passes in the coupon ident.
But when I execute this sproc, I get the following error:

Syntax error converting the varchar value '<html>......"

What am I doing wrong? Are there problems with the datatypes I"m
using?

Thanks in advance for any help on this?

.

Follow-Ups:
- Re: SQL Function
  - From: Erland Sommarskog
- Re: SQL Function
  - From: Jack Vamvas

Prev by Date: Re: Conditional Query
Next by Date: Re: SQL Function
Previous by thread: Conditional Query
Next by thread: Re: SQL Function
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Function
... I am calling this function in a sproc that passes in the coupon ident. ... Syntax error converting the varchar value '......" ...
(comp.databases.ms-sqlserver)
Re: SQL Function
... I am calling this function in a sproc that passes in the coupon ident. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)