SQL query for fuzzy searches?

[dwbh]

Hi,

I'm a wayward Lotus Notes developer who finds himself having to come up with a search engine back-end agent for an Oracle DB. I'm very much a newbie with SQL, but so far, I've got a dynamically-built query that will do straight searches like a champ. However, I'd like to be able to do fuzzy searches, and someone mentioned that I might be able to modify my basic query to accomodate this. If my basic query template is "SELECT Field FROM Table WHERE Value LIKE 'ABC*'", is there a variant of this basic query that will do the fuzzy searches I'm looking for?

Muchas gracias,
Sam

 

[SQLSister]

You are very wayward, this is not an Oracle forum. We could probably give you what you want but it won't necessarily work on an Oracle back end. When you repost on the Oracle forum, you might want to better explain what you nmean by a fuzzy search, this could mean different things to differnt people.

 

[dwbh]

Oh OK, sorry about that. I thought this was a general SQL forum -- my mistake. Thanks anyway.