Hello Kevin,

KH> I'm curious, would the following have the same result as using STARTING
KH> WITH? Because this is how I probably would have written it:
KH> select p.name, d.DateOfDiagnosis
KH> from patient p
KH> join diagnosis d on d.patientid=p.patientid where d.diagnosis
KH> like '206%'
Yes, it would, unless you use parameter for LIKE (LIKE :Param).


--
HTH
Best regards,
Pavel Menshchikov
http://www.ls-software.com