Wildcard for int in stored procedure

[katz]

hi,
newbie here.

Within a stored procedure is there any way to use a wildcard to compare a integer input parameter to a data type int field in the tables?
extract:

@DriverID int
WHERE
(DRIVER_ID =
CASE WHEN (@DriverID IS NULL) THEN '%'
WHEN (@DriverID NOT LIKE ' ') THEN '%'
ELSE (@DriverID)
END)

Thanx
[sig][/sig]

 

[TomSark]

Instead, I would simplify the problem as in:

IF @driver_id IS NULL
BEGIN
SELECT *
FROM TABLE
END
ELSE
BEGIN
SELECT *
FROM TABLE
WHERE driver_id = @driver_id
END

This will produce much more efficient code than using wildcards.

Tom [sig][/sig]

 

[katz]

HI,
THANKS FOR THAT, BUT WOULD THIS WORK IF THERE ARE MULTIPLE CLAUSES? [sig][/sig]

 

[jcrivera]

katz,
I would suggest to use CONVERT(VARCHAR(4),@DriverID) and assign it to another varchar(4) variable, in that way you could use nulls and/or wildcards.

Just a thought.

J.C.
[sig][/sig]

 

[TomSark]

Or you could use EXECUTE to build the select statement once, dynamically. I would either simplify the code, or use EXECUTE... depending on your needs. Eliminating the wildcard, if you can, is always better (as J.C. suggested).

Tom [sig][/sig]