*** 5,12 **** ---- ! *: Extended POSIX regular expressions (should be easy, man 3 regcomp, or http:// ! mirbsd.bsdadvocacy.org/man3/regcomp.htm for reference) SELECT * FROM table WHERE name REGEX '[a-zA-Z]+_{0,3}'; *: The EXISTS keyword is not supported (IN is, but IN is only a special case of EXISTS). And what about --- 5,11 ---- ---- ! *: Extended POSIX regular expressions (should be easy, man 3 regcomp, or http://mirbsd.bsdadvocacy.org/man3/regcomp.htm for reference) SELECT * FROM table WHERE name REGEX '[a-zA-Z]+_{0,3}'; *: The EXISTS keyword is not supported (IN is, but IN is only a special case of EXISTS). And what about *************** *** 35,43 **** *: Rollup and Cube - _Who can tell me what this means?_ ! _::: I don't know much about it myself, but a quick google on the subject gives me... http:// ! www.winnetmag.com/SQLServer/Article/ArticleID/5104/5104.html and http://databases.about.com/ ! library/weekly/aa070101a.htm _::: both of these imply that the CUBE operator causes new rows to be generated to give a wildcard value to non-numeric columns and summing the numeric columns which match those wildcards. The --- 34,40 ---- *: Rollup and Cube - _Who can tell me what this means?_ ! _::: I don't know much about it myself, but a quick google on the subject gives me... http://www.winnetmag.com/SQLServer/Article/ArticleID/5104/5104.html and http://databases.about.com/library/weekly/aa070101a.htm _::: both of these imply that the CUBE operator causes new rows to be generated to give a wildcard value to non-numeric columns and summing the numeric columns which match those wildcards. The