ToeJamNEarl
Programmer
Hey guys,
I have in a VB application two text boxes that the user can enter a range that they would want to query off of the server. The user can have the option of inputing as much of the range information they know when creating their ranges.
I am wondering is there anyway I can use LIKE (for the wildcard search) in conjunction with BETWEEN?
If not, any ideas as how I can accomplish my goal of being able to create an sql search with a range that has sort of a wildcard functionality for the input range?
Thanks in advance,
-Diran
I have in a VB application two text boxes that the user can enter a range that they would want to query off of the server. The user can have the option of inputing as much of the range information they know when creating their ranges.
I am wondering is there anyway I can use LIKE (for the wildcard search) in conjunction with BETWEEN?
If not, any ideas as how I can accomplish my goal of being able to create an sql search with a range that has sort of a wildcard functionality for the input range?
Thanks in advance,
-Diran