Firebird [Order by]: alphanumerisch / numerisch

[omata]

Vielleicht so...

SQL-Code:

CREATE PROCEDURE LEN (STR VARCHAR(100)) RETURNS (LEN INTEGER)
AS
DECLARE VARIABLE pat VARCHAR(100);
BEGIN
  len = 0;
  IF (str IS NOT NULL) THEN BEGIN
    pat = '';
    len = 0;
    WHILE (NOT str LIKE pat) DO BEGIN
      pat = pat || '_';
      len = len + 1;
    END
  END
  SUSPEND; 
END

SQL-Code:

SELECT bez
FROM personen
ORDER BY (SELECT len FROM Len(bez)), bez