Nick Chan wrote: > > how to search a % character? > > SELECT * FROM PROJECT_ WHERE NAME_ LIKE .............. >
Didn't you find it in our reference manual ? Please see http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/frameset.htm LIKE '%\%%' ESCAPE '\' (or any other special character not being part of stored names instead of \) Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
