This sample may help you to play around.

CREATE PROCEDURE dbo.PROV_SRCH

--from the search screen:

  @LastName varchar(40),

  @FirstName varchar(25),

  @spec varchar(40),

  @City varchar(30),

  @Zip varchar(10),

  @CompanyID varchar(10),

  @ProvID varchar(20),   

 ...

Hi Morgan:

Thank you for your snippet. It does the trick.

RGDS

Sam

Hi Morgan:

Thank you for your snippet. It does the trick.

RGDS

Sam

Hi Phil,

I been advised to post this question to General Forum. Check this forum for the same question. Thank you for your post. Running your quiery produced

2345.00 instead of 23.45

I would...

Rajesh,

Thank you for your post. It worked.

SQLBill,

This was my first question for this site, sorry I messed it up.

RGDS

Sam

Nano,

You may be right. But strangely enough I have been building sp in my search engine and conventional statement didn't worked right. I rewrote statement in dynamic sql and it...

Hi Amol:

Could you share your Active X script. I have to parse and load EDI 834/7 to SQL. It would be great to learn your experience with 850 files.

RGDS

Sam