Does anyone know the syntax for the LIKE operator or whether it's even supported? I tried the following the following; two of which I took from the POET OQL Reference Guide. where lastName LIKE "Si*" where lastName = "Si*" where lastName LIKE "Si%" where lastName = "Si%" The LIKE operator appears to be ignored and results in all rows being returned. Nothing is returned in the other scenarios. Eric
DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.
