Special characters in LIKE statement

I am looking to perform the following in SQL Server 2005 but I guess due to the character '#' the LIKE statement does not seem to be returning any result.

SELECT * FROM Table WHERE keyword LIKE '%C#%'

Please advice.

Answers


I guess there is no string in your table which contains "C#" this string.


The only time you escape keywords in LIKE statement is when you are searching for %, _, and [. So that means # is ok.


Must be something else. Check this SQL Fiddle working code using # character


Need Your Help

CSV response on sails js

node.js sails.js

I'm using sails js http://sailsjs.org/#!documentation and I want to response a csv file as a result from a db query someting like this:

When any browser saves a file on android, is there a broadcast sent? How can I intercept saved/downloaded files in a browser on Android?

java android image android-intent

I want to create an application where users can choose to save a file into my application and go through an activity to do so.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.