Problem about Select Count | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem about Select Count

ant:run:you
ink:run:rt
opp:we:ij I want to find the number of row that doesn’t include the word ‘run’ I tried this but I feel that it is wrong Select count(*) from db2 where mytext not like ‘run’ Any comment !!
http://www.sqlteam.com/item.asp?ItemID=1491 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Should be
Select count(*) from db2 where mytext not like ‘%run%’ —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br /<a target="_blank" href=http://www.sqlteam.com/item.asp?ItemID=1491>http://www.sqlteam.com/item.asp?ItemID=1491</a><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Satya, I think you have given wrong link and may be for other question [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Oh my … <br />Thanks for the correction Madhivanan, I blame IE [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
]]>