By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Issue with query results

P: 1
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
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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.