Re: Detecting typos

On 15 Dec 2004 03:28:08 -0800, "CE" <charlie3101_at_hotmail.com> wrote:

>This works ok (I've got to watch out for comparing MARY and MARK etc,
>though), but doesn't handle a comparison where there might be a missing
>letter (e.g. "CATHERINE" and "CTHERINE"). Can anybody think of
>anything a little bit cleverer?

You could try the in-built soundex function, which collapses any string to how it sounds. Works for English.

--
Sybrand Bakker, Senior Oracle DBA