Create a procedure with PSQL 8

[Mimi2012]

Hi,

I'm trying to create a stored procedure that seeks a string (eg '0099 ') in a column of type 50 times PIC 9(4)
COMPANIES column is as follows:
0099006901610169000000000000000000000000000000000000000000000000000000000

Here is my sp:

CREATE PROCEDURE usp_GetCompanyInfo (in: CompanyID char (4))
RETURNS (
Group integer,
Name varchar (30)
);
BEGIN
SELECT GROUP NAME
FROM MYTABLE
WHERE (COMPANIES LIKE: CompanyID);
END;

When I execute the SP
usp_GetCompanyInfo call ('0099 ')
it does not work

Thanks for your help!

Mimi