bonjour, dans une base intégrée hsqldb, : <doc hsqldb> LOCATE(search,s,[start]) returns the first index (1=left, 0=not found) where search is found in s, starting at start </doc hsqldb> ressemble à ce que tu cherches, avec quelques différences néanmoins.
il y a aussi : <doc hsqldb> The LIKE keyword uses '%' to match any (including 0) number of characters, and '_' to match exactly one character. To search for '%' or '_' itself an escape character must also be specified using the ESCAPE clause. For example, if the backslash is the escaping character, '\%' and '\_' can be used to find the '%' and '_' characters themselves. For example, SELECT .... LIKE '\_%' ESCAPE '\' will find the strings beginning with an underscore. </doc hsqldb> qui n'est pas une fonction mais une clause dans le WHERE. http://hsqldb.org/web/hsqlDocsFrame.html Bone journée --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
