Modify VB.net SQL search to use pattern

Question

The code below works great, and I need it to do more :). It is for vb.net 2008 with access database. At the moment it matches based on paramValue, and needs an exact match. How can I change it to look for a pattern instead?? For example I want anything that contains the text "Fizz" and then "Bom".
--And PLEASE share any link where I can learn about this blend of SQL+access+vb.net. Thank you! Steve

Dim table As New DataTable(tableName)
table.Locale = System.Globalization.CultureInfo.InvariantCulture

Using connection As New OdbcConnection(ConnectionString)
    connection.Open()

    Dim query As String = String.Format("SELECT * FROM [{0}] WHERE [{1}] = ?", _
                                        tableName, _
                                        paramName)
    Dim selectCommand As New OdbcCommand(query, connection)
    selectCommand.Parameters.Add(New OdbcParameter("@" & paramName, paramValue))

    Dim adapter As New OdbcDataAdapter(selectCommand)
    adapter.FillSchema(table, SchemaType.Mapped)
    adapter.Fill(table)
End Using

Return table

@user414564 You should vote up and / or accept answers that are useful to you, because it helps both the person answering and anyone who finds this question in the future. — Fionnuala
– Fionnuala, Commented Feb 9, 2011 at 13:14
Thanks. LOL, I dont have enough rep to vote up, and dont know how to accept an answer. Will learn how now. — CodeMonkey_Steve
– CodeMonkey_Steve, Commented Feb 24, 2011 at 18:51

BIBD · Accepted Answer · 2011-02-09 17:58:20Z

1

Reference link : HERE

Dim SelectQry = "SELECT * FROM [{0}] WHERE [{1}] like '%" & _
                    strYourSearchValue & " %'"

edited Feb 9, 2011 at 17:58

BIBD

15.5k26 gold badges89 silver badges142 bronze badges

answered Feb 9, 2011 at 12:20

ashish.chotalia

3,73630 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anuraj · Accepted Answer · 2011-02-09 12:18:47Z

0

You can use a LIKE operator to do that.

SELECT * FROM TableName WHERE Name LIKE '%Fizz%' AND Name LIKE '%Bom%'

answered Feb 9, 2011 at 12:18

Anuraj

19.6k7 gold badges61 silver badges84 bronze badges

Collectives™ on Stack Overflow

Modify VB.net SQL search to use pattern

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related