Optional Variables

[Kim Green]

What's the proper syntax to indicate that a variable is optional? The script
that I have created works great when I pass in a variable, but the script
need to execute the SQL even if I don't pass in a variable.

Thanks,
Kim