title: How to use SIMILAR TO with variables
body: <p>I have a function with a <code>SELECT</code> using a <code>SIMILAR TO</code> expression with a variable and I don't know how to do it:</p>
  <pre><code>DECLARE pckg_data cl_data;
  DECLARE contacts contacts_reg%ROWTYPE;
  DECLARE sim_name varchar;
   BEGIN
  SELECT client_reg._name, 
         client_reg.last_name, 
         client_reg.id_card, 
         client_reg.address
  INTO pckg_data
  FROM client_reg WHERE(client_reg._name = (cl_name ||' '|| cl_lastname));
  RETURN NEXT pckg_data;
  
  SELECT ('%'||cl_name || ' ' || cl_lastname ||'%') INTO sim_name;
  
  FOR contacts IN SELECT contacts_reg.id 
  FROM contacts_reg, contactscli_asc, client_reg
  WHERE(contacts_reg._name SIMILAR TO sim_name) LOOP
      SELECT client_reg._name, client_reg.last_name, client_reg.id_card,
                     client_reg.address, client_reg.id
      INTO pckg_data
      FROM client_reg, contactscli_asc WHERE(contactscli_asc.contact = contacts.id 
      AND client_reg.id = contactscli_asc.client);
  END LOOP;
  
  END;
  </code></pre>