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 :) |
|
|
|
|
|