Re: [sqlite] LIKE problem

;page" = a series of unknown bytes. The data string "pageup" satisfies the last two requirements but not the first. Therefore you do not return a row. Solution = use "LIKE 'page%' At 09:14 PM 5/15/04 +0200, you wrote: Sascha, On 15 may 2004, at 10:48, Sascha Kueh

Re: [sqlite] LIKE problem

query to map my database, I get the expected rows. In my case I write the following: SELECT * FROM address WHERE last LIKE '%iur%' Works fine for me... Please give me more info: what OS are you using? SQLite version? Regards, -- Tito On 15 may 2004, at 15:14, Sascha Kuehn wrote: Sascha,

Re: [sqlite] LIKE problem

Sascha, On 15 may 2004, at 10:48, Sascha Kuehn wrote: here is my selectstatement: "SELECT * FROM WorkBook WHERE name LIKE '%page%'" the workbook table contains several rows where "name" contains "pageup" and i want to get only this rows. but the selectst

[sqlite] LIKE problem

is rows. but the selectstatement doesn't work. can somebody help me? thanx in advance sincerely yours Sascha Kuehn Applescript Developer www.nullify.de/nullifySoftware/en/