I think you mean % not * % is the wildcard. -alex On Jun 13, 2006, at 3:03 PM, Alex Roston wrote:
Does SQLite have anything resembling a wildcard function? I need to either get rid or modify a whole group of rows which have some common elements in the primary key.Ideally I'd like to do something like: "UPDATE card SET foo='100' where bar='ABC*';" The construct above doesn't work, but is something like it possible? Thanks, Alex
