Hello Cetin,
In this example, I wanted 1 record returned...and SET ANSI of course solved that. I want to have one view that could return one record if both parameters are the same, or a range of records. The BETWEEN is another solution for me to consider. But there is also the need to retrieve all items that start with the same style number (your LIKE example). So I'm probably going to end up with multiple views anyway.
Thanks for the reply,
steve
>>
>>Trying to make a parameterized view that can get a range of records, or only one record if start and ending values are the same. But it is a bust at this point.
>>
>What do you want from SQL? 1 result or 4?
>
>* Only exact match - independant from set ansi
>select * from itemMast where itemnum == "B2456DI14"
>*ANSI dependant
>select * from itemMast where itemnum = "B2456DI14"
>*ANSI independant
>select * from itemMast where itemnum like "B2456DI14%"
>
>set exact has no effect on SQL.
>Cetin
Steve Gibson