FAQ Database Discussion Community


SQL LIKE Equivalent in C#

c#,linq,wildcard,like-operator
My question uses the following code - string searchString = dropdownlist.SelectedValue; List objects = (from o in Object.List() where dropdownlist.SelectedIndex <= 0 || o.CustomField.Contains(searchString) orderby o.Date descending select order).ToList(); The situation I am running into is as follows - The items in the drop down list are generic messages such...

Posgresql: finding multiple columns that match a like clause

sql,postgresql,like-operator
i am a sql-beginner and i have a lot of trouble to figure out how it goes. say i have a simple table: column 1 column2 column3 AA AAAA TT AA BB EE AB C AABBCC ABC XXX XYZ AABB YYY A now i tried to find all columns, that...

Get records with blank field value using LIKE statement

sql,sql-like,like-operator
I am using a filter criteria to pull records where my table shows dynamic search results based on the input text. below is the code I am using - Me.Bookbindingsource.Filter = *Book_Author LIKE '*" & TextBox.Text & "*'" This field can be blank. When form loads, I want it to...

Cassandra and advanced queries: Spark, ElasticSearch, Sorl

elasticsearch,cassandra,apache-spark,sql-like,like-operator
Ok, so, I'm developing an app and I'm using Cassandra as the database. Everything going good so far, but now I need to do a query using the LIKE clause. I know Cassandra doesn't support that, and that's why after looking for a workaround I was thinking in maintaining this...

LIKE operator in SSRS row visibility expression

reporting-services,textbox,ssrs-2008,visibility,like-operator
I have a text box within an rdl report which I want to suppress based on certain terms in my dataset (i.e. if the query returns a term which ends with the letter "L" then hide the text box). Within the textbox properties I have set visibility expression for Hidden...