I am creating a remote SQL Server view that uses parameters. There are character parameters passed and a date parameter. The user can fill in as many parameters as they want and before the remote view is queried I fill in the rest of the character based parameters with the "%" character. All the character parameters use the LIKE comparison.

My problem is how to define the date parameter. If the user does not enter a date then I need to put something in for the parameter like the "%" for the character parameters. What would that be? In addition, what comparison do I use? The data in the table may or may not actually have data in the date field which would mean special considerations would need to be made for empty dates (stored as 1/1/1900)

Any help with how I would do this would be very helpful.