List:MaxDB« Previous MessageNext Message »
From:Elke Zabach Date:October 15 2003 6:32am
Subject:RE: Proper Syntax
View as plain text  
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
Thread
• Proper SyntaxNick Chan15 Oct
• RE: Proper SyntaxElke Zabach15 Oct