Re: Parameter default value


MGFoster wrote:
> CREATE PROCEDURE Proc5 (
> argdata_col VARCHAR(10) = 'Hello'
> ) AS
> SELECT key_col, data_col
> FROM Test
> WHERE data_col =
> CASE WHEN argdata_col IS NULL
> THEN data_col
> ELSE argdata_col
> END

Now that I think about it, your parameter name is illeagal. Also,
COALESCE is elegant here:

CREATE PROCEDURE Proc5 (
@data_col VARCHAR(10) = 'Hello'
) AS
SELECT key_col, data_col
FROM Test
WHERE data_col = COALESCE(@data_col, data_col)

Back in Access/Jet, any ideas about getting that default parameter
value?

.