This discussion is archived
3 Replies Latest reply: Feb 4, 2013 4:23 AM by shabar RSS

Column comparison in same Table with exception

shabar Newbie
Currently Being Moderated
Hi All


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

Following should tally
'ABcd f' = 'AbCDf'
'xyz ..' = 'xy z'
How is it possible


Cheers

Shabar

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points