Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: Sort Codes


I am the Jammie King!




Status: Offline
Posts: 12735
Date: Apr 19, 2004
Sort Codes


I just thought I'd share the cause of my frustration with you.


Sort codes.  They're a simple concept.  Each branch of each bank in the UK has a six digit sort code which uniquely identifies it, right?  The first two didgist identify the bank - 30 is Lloyds, 60 is Nat West 20 is Barclays and so on; and the next 4 identify the branch. Easy.


We have about 2500 branches.  We also have 4 more digits to play with, so it should be really, really easy to provide each branch with it's own sort-code.


Shouldn't it?


Noooooooo.    OUR bank supplements many of these with 8 digit sort codes - an extra 2 digits on the beginning or end, sub branches that share sort codes with their parent branches and branches that have NO SORTCODE AT ALL!


To add to my frustrations, not one of the bank's systems stores the same sort codes in the same format.  Any given branch will be shown with a 6 digit code on one system and an extra 2 digit prefix on another and 2 extra digits on the end on another.  And some branches have entirely different sort codes on different systems.


And then there's the f*****g DUPLICATES.


Sorry.  I'm over it now.



__________________
The King has spoken... But nobody listened.


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Apr 19, 2004

See:

Select Distinct
Left$(), Right$(), Len()
And conversion functions.



__________________
You can't polish a turd


Tickle me, Elmo!

I'm Roger Moore's Stunt Double!



Status: Offline
Posts: 4936
Date: Apr 19, 2004

Oooh Nate, you're a real man!


Only a man believes a someone shares a problem in order that someone else can solve it.


A woman believes someone shares a problem to receive sympathy and therefore feel better about the problem!



__________________
Don't you just love it?


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Apr 19, 2004

Right! You'll get no sympathy from me.

Susan, me ol' mucker, isn't this described in the acclaimed book, 'Men are from Earth and Women are from Outer Space?'

Perhaps I have it backwards...

__________________
You can't polish a turd


Tickle me, Elmo!

I'm Roger Moore's Stunt Double!



Status: Offline
Posts: 4936
Date: Apr 19, 2004

The very same.  Not a bad book.


don't believe everything in it though - contrary to popular belief some women can read a map without turning it upside down!



__________________
Don't you just love it?


I am the Jammie King!




Status: Offline
Posts: 12735
Date: Apr 19, 2004

I know all them there functions Nate.  It's just annoying that I should need to use 'em.


As for girls.  I think you're wrong.  They're not from outer space.  They're from another dimensional plane!



__________________
The King has spoken... But nobody listened.


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Apr 19, 2004

Don't shoot the messenger! I neither: Created the DB nor wrote the book. Bon chance.

__________________
You can't polish a turd


I am the Jammie King!




Status: Offline
Posts: 12735
Date: Apr 19, 2004

Dude, I shall polish the database as soon as I get to work in the morning!  It won't work though.....

__________________
The King has spoken... But nobody listened.


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Apr 19, 2004

Right, you can't.

__________________
You can't polish a turd
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Post to Digg Post to Del.icio.us


Create your own FREE Forum
Report Abuse
Powered by ActiveBoard