Made a typo in previous message - substitute "from C_Patient" with "from
MYTABLE"
Hopefully this should give the results you want

Select distinct C_PATIENT
, (Select first 1 Date
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as DATE1
, (Select first 1 ITEM
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as ITEM1
, (Select first 1 skip 1 Date
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as DATE2
, (Select first 1 skip 1 ITEM
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as ITEM2
, (Select first 1 skip 2 Date
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as DATE3
, (Select first 1 skip 2 ITEM
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as ITEM3
, (Select first 1 skip 3 Date
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as DATE4
, (Select first 1 skip 3 ITEM
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as ITEM4
, (Select first 1 skip 4 Date
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as DATE5
, (Select first 1 skip 4 ITEM
from MYTABLE b
where b.C_PATIENT = a.C_PATIENT
order by b.C_PATIENT, b.DATE) as ITEM5
from MYTABLE a

Regards Cao
-----Original Message-----
From: firebird-php@yahoogroups.com [mailto:firebird-php@yahoogroups.com]On
Behalf Of Didier Gasser-Morlay
Sent: 18 May 2007 01:16
To: firebird-php@yahoogroups.com
Subject: [firebird-php] English/ukrainian


In PHP I understand there is a specific extension (mbstring) whichs
deals with multi byte issues.

as I understand it, the Ukrainian language (cyrillic) does not really
requires multi byte, (but then again I am just brushing the issue).

IF I understand you correctly, you seem to imply that I need to upgrade
to FB 2. I'll give that a go.

Thanks for the input

Didier





[Non-text portions of this message have been removed]