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:

Anonymous said...

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/