Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-22 : 07:36:22
|
| Kalpesh writes "Hi,I am facing one problem,In the below link I have to passvariable value in single quote..inside the SP.set @PassAdd=('http://drm4capes:111/PropMart/NfindComp?Query=Call mrlibp3.nfindprop(Null, ' +ltrim(rtrim(@range))+', '+ltrim(rtrim(@name))+' ,Null,NULL, '+ltrim(rtrim(@State))+','+ltrim(rtrim(@zip))+' )')this is result for above query..'http://drm4capes:111/PropMart/NfindComp?Query=Call mrlibp3.nfindprop(Null, 225, CRANE ,Null,NULL, FL,34293 )'but I have to pass value like this ...'http://drm4capes:111/PropMart/NfindComp?Query=Call mrlibp3.nfindprop(Null, '225', 'CRANE' ,Null,NULL, 'FL',34293 )'Can any one please reply ...how to pass variable value in single quote ...thanks -Kalpesh" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-22 : 07:56:57
|
| 'http://drm4capes:111/PropMart/NfindComp?Query=Call mrlibp3.nfindprop(Null, ''225'', ''CRANE'' ,Null,NULL, ''FL'',34293 )'==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
How can we variable value in single quote