SQL Server 2005 Full text search - Searching for numbers

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2010-04-08T08:59:10Z Indexed on 2010/04/08 9:03 UTC
Read the original article Hit count: 337

Hi all,

I using the SQL Server 2008 FTS feature in a project. When searching for a phone number like CONTAINSTABLE(table, *, '"01739470869"'), this query also returns records containing the number '01739468996', which is similar. Does anyone know how I can get an exact match from a number?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server