On 9 Aug., 16:53, charly <[email protected]> wrote: > This would be a proprietary feature of H2 (and maybe other databases > like the above mentioned Oracle) > and is fine, if the SQL-statements are running only on H2 i.e. need > not be portable.
I'm not sure what kind of escaping is being talked about. If this is the character that is supposed to turn a SQL wildcard in a regular character (so that you can e.g. search for % sign) then there _is_ a standard for this: SELECT * FROM my_table WHERE some_column LIKE '\%' escape '\'; This is defined in the SQL standard and to supported at least Postgres, Oracle, SQL Server and DB2. Regards Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
