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 |
|
cez
Starting Member
37 Posts |
 Posted - 2002-12-07 : 10:04:26
|
| Hi !I'm using asp.net for a web application. I'm using a stored procedure to insert some varchar values, and the .net takes care to handle " ' ". But when I perform some selects later in a stored procedure, it breaks because of some " ' ". Is there any way to excape them in my stored procedure ?Thanks |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-07 : 10:24:34
|
| Post your select statement that you're using in .netYou probably just need to replace ' with '' that's two ' for every '.In VB you can use the replace function and T-SQL also supports a replace function.Edited by - ValterBorges on 12/07/2002 10:25:50 |
 |
|
|
cez
Starting Member
37 Posts |
Posted - 2002-12-07 : 10:42:43
|
| Thanks, it works just great |
|
|
|
|
|
|
big quotation problem