Hi Andreas, > This is what I tried so far in parsed SQL mode: > SELECT * FROM "Table" WHERE "Name" LIKE Concat( '%', Concat( [X],'%' ) ) > > SELECT * FROM "Table" WHERE "Name" =[X] > obviously this syntax does not work at all.
Sounds like an outdated help file. Since those are impossible to update while passing, we need an issue - volunteers? > SELECT * FROM "Table" WHERE "Name" LIKE Concat( :X, '%' ) > does not ask for X http://www.openoffice.org/issues/show_bug.cgi?id=91208 Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
