Issue with query results

[mus24]

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.

[ck9663]

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...Googl e use a similar thing for indexing and search engine.

We could be rich :)