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 |
|
ann
Posting Yak Master
220 Posts |
 Posted - 2006-06-22 : 12:23:08
|
| Hi - I have a dyn. sql statement (I need it because of sorting for datagrid in .net). I have everything working except I am stuck on:WHERE 1=1 AND status <> 'closed' I'm unsure how to handle the quotes around closed? I tried to double quote, but that didn't seem to work. Any ideas....anyone?Thanks for any help you can provide |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2006-06-22 : 12:32:52
|
| Try this status <> '''closed'''You need to escape a single qoute with another singleqouteKarunakaran |
 |
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2006-06-22 : 12:35:46
|
| thanks for replying so quickly! That worked :) |
|
|
|
|
|
|
Syntax issue