Wednesday, June 24, 2009

Phonetic Matching (=*) & Pattern Matching (% and _)

Phonetic matching (Sounds-Like Operator =*)
e.g.
where custname =* 'Lafler';

Finding patterns in a string (Pattern matching % and _)
e.g.
where prodtype like '%soft%';
where prodtype like '____a%';

1 comment:

  1. AnonymousMay 14, 2014

    Be it big, small, luxurious or bulky, Toyota manufactures
    and markets all kinds of vehicles. The body is tough and
    almost impervious to mud, dirt and rain, which makes the latest Toyota
    model offerings perfect for off-road enthusiasts. Like all cars the Toyota Yaris will
    require routine maintenance from time to
    time.

    Feel free to surf to my web-site - http://www.youtube.com/

    ReplyDelete