Thanks Mark, I was wondering how to do that anyway. I've been using something like >= "C" and <= "CZZZZZZZ". Not to smooth, huh?
>>Noticed these messages, thought I'd put my two cents in. I just have a regular membership and can read the article (and have a few times as matter of fact), so you should be able to read it.
>>I also noticed your thing about the paramters for the remote view. If you use the LIKE command you need to use a '%' somewhere in there too, you may want to check with Mark, I've just go into Oracle myself, but I know that you need the percent sign in there somewhere.
>>
>>>Finally some good news -- of course I have to ask again for my own sanity -- You are use remote parameterized view (... where city like ?pcCity ...)????
>>>
>
>The variable (parameter) should have the percent signs included.
>
>pcCity = "%" + AllTrim(CityString) + "%"
ICQ 10556 (ya), 254117