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.
|