Column comparison in same Table with exception

[shabar]

Hi All


I needs to compare two column values in same table in access. But should ignore few characters like space comma, dot

Following should tally



'ABcd f' = 'AbCDf'
'xyz ..' = 'xy z'


Cheers
Shabar

[June7]

How many different characters will there be that need to be ignored?

Replace(Replace(Replace([fieldname], " ", ""), ".", ""), ",", "")