Should your query not be something like this: select count(*) from blocklists where blockval like '%alexandre%'
RBS -----Original Message----- From: Alexandre Busquets Triola [mailto:[EMAIL PROTECTED] Sent: 24 November 2006 23:48 To: sqlite-users@sqlite.org Subject: [sqlite] select help Hi have this table CREATE TABLE [blocklists] ( [blockval] VARCHAR(255) NOT NULL ) insert into blocklists blockval values('%lex%'); and I need do something like this select count(*) from blocklists where 'alexandre' like blockval How i can do something like with sqlite? That i need is something how in string ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------