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 |
|
DENIZ3E
Yak Posting Veteran
56 Posts |
 Posted - 2005-12-26 : 06:43:40
|
| hý,ý want to search character " ' " ýn my tableselect code from TABLE WHERE CODE LIKE '''but ERRORRRServer: Msg 105, Level 15, State 1, Line 1Unclosed quotation mark before the character string '''.Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '''. |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-26 : 06:49:01
|
| Hi,use two "''" instead of "'" |
 |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-26 : 06:50:04
|
| try thisselect code from TABLE WHERE CODE LIKE '''' |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-26 : 07:46:10
|
| orSelect columns from yourTable where charindex('''',code,1)>0MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
select