[thelist] Stored procedure

Your line should read

SELECT @sDescription = 'steve and ''john'' went on a trip'

When using single quotes in a variable assignment they need to be escaped
with the single quote.


Jeremy Schell
Senior Internet Developer/Technical Lead, Interactive
Doe Anderson, Inc.
(502) 815-3339



                      "Stevenson Ngila"
                      <Stevenson at epr.footman-     To:       "Thelist at Lists.olt. Org" <thelist at lists.evolt.org                      walker.com>                    cc:
                      Sent by:                       Subject:  [thelist] Stored procedure
                      thelist-admin at lists.evo                      lt.org


                      02/03/2003 02:11 AM
                      Please respond to
                      thelist






hi all,

I want to run a stored procedure sp_testing @sDescription as ntext where
@sDescription  is:- 'steve and 'john' went on a trip'.

But John is in quotes and this data is feed automatically, how can i make
this run.

i have tried using sp_testing replace (@sDescription, '''', '''''') as
ntext, but it's failing.

Please assist


--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !