no, but have a look at some of the tsql implementations of Levenstein Edit
Distance.
SQL 2005 Integration Services has a fuzzy lookup component which may work
for you.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<goyald_at_gmail.com> wrote in message
news:1123514686.757953.315070_at_g43g2000cwa.googlegroups.com...
> Hello
> My input data consists of a string field. I need to find rows where
> this string field is matching "approximately"!! i.e. I need some kind
> of a fuzzy match.
>
> Is there any such inbuilt facilitty/function in SQLServer or Oracle?
>
> Thanks and regards
>
Received on Mon Aug 08 2005 - 10:45:30 CDT
