467,149 Members | 1,200 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

Issue with query results

Hi All,

I have an issue where my query results are to be "less sensitive" to various syntax
For example:

SELECT * FROM Player_Profile
WHERE txtname
LIKE 'AJ Abrams'

But the results are to return all records similar to 'AJ Abrams' such as the records which have "." or white space for example:
'A.J. Abrams' or 'A J Abrams'

So if I were to query 'AJ Abrams' the other records such as 'A.J. Abrams' and 'A J Abrams' should return as well.

I have used a Replace function but it doesn't seem to work.

Thanks a bunch.
Jan 26 '09 #1
  • viewed: 1060
Share:
1 Reply
ck9663
Expert 2GB
It's called field normalization. It's also being used in addresses, specially when you're trying to match/compare two address or two names. Once you have something, post it here hehehhe...Google use a similar thing for indexing and search engine.

We could be rich :)
Jan 28 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by bc | last post: by
2 posts views Thread by tina.boroff@gmail.com | last post: by
1 post views Thread by David Miller | last post: by
2 posts views Thread by dm1608 | last post: by
reply views Thread by Wescotte | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.