Nick Chan wrote: > i have a column NAME_ > one of the records is NAME_ = %% > > i did this > > select * from supplier_ where name_ like '%\%\%%' > > but no result?
You missed the ESCAPE clause. Try it with select * from supplier_ where name_ like '%\%\%%' escape '\' Kind regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
