I will try it.

You guys are good.  I have a lot to learn.

Thanks- to all.

I'll try that.

Thanks!

I don't understand your response.  If the word 'QUOTATION' is not found then @Counter = 0.

The answer to my original problem, as it turns out, was because I was not...

Yes, if the word 'QUOTATION' is not found, this is common.

Sure enough - they show up as new lines!

Thanks.

That's what I'm thinking.  When I copy and paste it, it must change a CR or LF to a space.

Jim

I'm not getting an error, just not the expected results.  When I run the function sending it a text string it works.  When I run it and pass it the...

It's a scalar function.  Here is the sql:

CREATE FUNCTION GetQuoteNumberFromUserText

 (@UserText TEXT)

RETURNS VARCHAR(12)

AS

BEGIN

 DECLARE @TempUserText VARCHAR(255)

 DECLARE @Result VARCHAR(12)

 DECLARE @Var CHAR(1)

 DECLARE @Counter TINYINT

 IF @UserText IS NULL

   SET @Result = ''

 ELSE

  BEGIN

  SET @Var = ''

  --Check to...

what is the 'dateadded' field?

Thanks

Thanks for the article.  I just upgraded to VB.net 2005 from VB6 and started using TableAdapter objects to connect to SQL Server and stored procedures.  It seems to work OK. ...

Thanks!  I knew there must be an easy way.