>>> <pez@aiming.net> 01.12.1999 15.07 Uhr >>>
>> I am trying to do a query with a partial search but don't know the
>> syntax. eg. I want the word 'buff' to find 'buffalo' in the variable
>> 'city'. Can anyone give me an example?
>>
>>--
>>Cheers,
>>
>>Derek
select * from table where city like 'buff%';
-------------------
Gerhard