Hi,

I juse this code for a stored procedure:

BEGIN
DECLARE Result CURSOR WITH RETURN FOR Stmt;

  BEGIN
  PREPARE Stmt FROM 'SELECT * from Patienten where
                     Name = ? and Vorname = ?';
  OPEN Result using Name, Vorname;
  END;
END

Works fine. How can I use the like-operator together with the parameters in a Stored
Procedure, something like this:

  PREPARE Stmt FROM 'SELECT * from Patienten where
                     Name like ?% and Vorname like ?%';


Regards Uli

Uli,

<< Works fine. How can I use the like-operator together with the parameters
in a Stored Procedure, something like this: >>

Use this:

BEGIN
DECLARE Result CURSOR WITH RETURN FOR Stmt;

  BEGIN
  PREPARE Stmt FROM 'SELECT * from Patienten where
                     Name = ? and Vorname = ?';
  OPEN Result using Name+'%', Vorname+'%';
  END;
END

--
Tim Young
Elevate Software
www.elevatesoft.com

<<
OPEN Result using Name+'%', Vorname+'%';
>>

This is tricky Thanks a lot.

Regards Uli

Uli,

<< This is tricky Thanks a lot. >>

Well, you could have embedded the % characters in the actual SQL text also,
but it would have been a lot less readable.

--
Tim Young
Elevate Software
www.elevatesoft.com

Uli

>This is tricky Thanks a lot.

Dead right - I've applied for a brain upgrade

Roy Lambert