Jim,
See change below
HTH
>Hello,
>
>I am trying to call a stored procedure on a SQL Server 7.0 database. The procedure accepts a parameter called name. The procedure uses a select to return records, the select statement is based on the parameter passed. If I pass part of a name (ex: Jim) the procedure returns 0 records. If I pass a full name (ex: Mr. Jim Rieck) I get one record back. The code is below, any ideas?
>
>CREATE Procedure getGuest
>(
> @Name char(50)
>)
>
> AS
> SELECT * FROM guests WHERE name like "%" +
RTRIM(@name) + "%"
> return
Daniel