Thread

Antw: [SQL] Partial Search

Gerhard Dieringer <dieringg@eba-haus.de> — 1999-12-01T14:50:09Z

>>> <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