LISTING 1: Stored Procedure from an Access Project Showing the IF Statement's Basic Syntax

Alter Procedure spAuthorsInAState
@mystate char(2)
As
--If there are records, select them and set RETURN to 1
IF (SELECT COUNT(*) FROM authors WHERE state=@mystate)>0
	BEGIN
		SELECT au_fname, au_lname, state
		FROM authors
		WHERE state=@mystate
		RETURN 1
	END
ELSE
--Otherwise, set RETURN to 0
	RETURN 0