Does sqlite contain a function that would look at every row in a column and find the ones contain a string I supply it with. I'm trying to make a dynamic database search that would query retrieve rows from the database every time I type a new letter into my search box for a desktop app.

What about using LIKE for pattern matching.

that worked. Thanks a lot

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.