• Richie88
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

Hey Guys,

 

Basically I have two fields.

 

Account Number & Account Number Backwards.

 

The reason behind this is to make sure there is no human error when entering the account number by reversing the number and checking for a match.

 

My problem is I can't seem to find anywhere, a way to reverse this back to check its equal!

 

IE:

 

Account Number: 123456

Backwards: 654321


Match: Account Number = Reverse(654321)

 

As a quick example.

 

Has anyone thought of something simliar ? Or a better way of storing clients bank account details within the system?

 

Regards,

 

Richie