[dba-SQLServer]Passing params to SProc

Will this work for you?

Alter Procedure qlfrmTitle (@TI_ID Int = null)

As

SELECT * FROM dbo.tblTitle WHERE (((tblTitle.TTL_ID) =
IsNull(@TI_ID,tblTitle.TTL_ID))) ORDER BY
tblTitle.TTL_Title

	return

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of John W.
Colby
Sent: Thursday, 27 February 2003 4:48 p.m.
To: AccessD-SQLServer
Cc: AccessD
Subject: [dba-SQLServer]Passing params to SProc


I use autonumber PKs or whatever that was turned into in SQL during the
upsize.  So now I want to have an sproc with a param of type int, but have
the default value be the wildcard so that all records are passed back if no
param is provided.  Further I want to be able to pass in the wildcard in the
Input Parameters property of the form to load all the records if I have
previously narrowed it down.

Alter Procedure qlfrmTitle (@TI_ID Int = 0)

As

SELECT * FROM dbo.tblTitle WHERE (((tblTitle.TTL_ID) like @TI_ID)) ORDER BY
tblTitle.TTL_Title;

	return

Works to return no records.  Good so far.

Alter Procedure qlfrmTitle (@TI_ID Int = 1)

As

SELECT * FROM dbo.tblTitle WHERE (((tblTitle.TTL_ID) like @TI_ID)) ORDER BY
tblTitle.TTL_Title;

	return

works to return one record with the pk of 1 if no param is provided by the
form.  Good so far.

Alter Procedure qlfrmTitle (@TI_ID Int = %)

As

SELECT * FROM dbo.tblTitle WHERE (((tblTitle.TTL_ID) like @TI_ID)) ORDER BY
tblTitle.TTL_Title;

	return

refuses to save.  Doesn't like the %.  Likewise with *, likewise with '%'
etc.  I think perhaps the wildcard character is a text wildcard.  Is there a
numeric wildcard symbol or something?