Hello, I have a problem concerning a SQL-Statement. In the table S_Objekt I have a field S_Kapitel (varchar (15) binary) that contains chapternumbers like 2.2., 2.2.1., 1.1., 1.2.3. ... The Query is to give me all chapternumbers of a certain hierarchy. My Idea was to ask for the number of Points (".") : Two Points would give back "2.2." and "1.1." Three Points would give back "2.2.1." and "1.1.3." etc.
I tried to use a REGEXP, but didnt succeed. Can you help? Gruß aus Essen Sven Schäfermeier _______________________________________________________ Klickmeister GmbH - Schuermannstrasse 39 - 45136 Essen fon +49 201 26 97 387 fax +49 201 26 97 106 mobil +49 160 824 0 892 [EMAIL PROTECTED] http://www.klickmeister.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php