>I want to create a proc that pulls either a single record based in the RecId or all
>records if no Id was passed in.
>
>What am I doing wrong here?
>
>

>CREATE PROCEDURE syGetUser
>	@RecId integer = NULL
>
>AS
>
>	SELECT RecId,
>	       GroupId,
>	       FullName
>	       UserName,
>	       Password
>	  FROM appUsers
>	  WHERE (RecId = @RecId) OR ISNULL(@RecId)
>

>
>



Change the place of the conditions:
(Also ISNULL() function is not the same as in VFP. it is like NVL() VFP function)

CREATE PROCEDURE syGetUser
	@RecId integer = NULL

AS
  SELECT RecId,
	GroupId,
	FullName
	UserName,
	Password
  FROM appUsers
  WHERE (@RecId IS NULL OR RecId = @RecId)