I am having trouble with a search using a parameter off a remote view.
I created a table on the server and set my field as a char 12.Created a remote view to search by a field for shift Time on my report.
the problem is when i run the report and my parameter box pops up i enter (exp: 6am to 2pm) i get a error converting varchar to 6am to 2pm to a column of data type int. i have checked the table nd have checked both views and they are all set up as char 12.I dont understand what is the problem. any help is appreciated.

Thanks Linda