Update query to remove leading and trailing spaces from all columns throughout table

[Frothingslosh]

Well my full name is A B C, however I go by the name of B. I have never used A. It was selected supposedly to honour a Battle of Britain pilot who was killed, so the first born male would be called A.

Nightmare when I go to the doctor's surgery as I have to make a special effort to hear that name when they call my turn, which I never use.

How spies do it, I do not know.

Yeah, I know a guy Derek Scott Bland. Goes by Scott, and often doesn't realize that someone is talking to him if they call him Derek.

Of course, that has its own issues, since for many years there were four of us going by Scott in the M:tG scene around here. Even today, I'm more used to being called by my last name than by my first.

 

[jdraw]

kb44,
You have to get the specifications; analyze them and come up with feasible options.
HR has functional requirements and possibly some reporting requirements, but HR should not be designing the database. Designing that database is not - in my view - an HR function. Now it certainly depends on your organization and management and their approach to data/information management. We've seen enough spreadsheet databases and non-normalized table designs etc, etc. You offer some options that are feasible, doable and even some samples --but only after you get some analyzed and vetted specification.

 

[Gasman]

Yeah, I know a guy Derek Scott Bland. Goes by Scott, and often doesn't realize that someone is talking to him if they call him Derek.

Of course, that has its own issues, since for many years there were four of us going by Scott in the M:tG scene around here. Even today, I'm more used to being called by my last name than by my first.

Even worse for me.

My surname was A and my mother remarried and took her husbands surname and we had ours changed to B by deed poll.

My school decided that it would be easier for me if I went with both surnames to start with and then drop the old surname after a while. So i was called A-B by the teachers for a period, but really only ever picked up on the A.

Then they dropped the A and just called me B, and I would keep walking until they called out A!

I had a friend in school, D.W.S.P. Jones, David William Stanley Paul, and he was called Paul.

My half brother is W.D.K, William after his father and grandfather, Donald after his uncle, and Keith as my parents liked that name, and he is called Keith.

 

[kb44]

kb44,
You have to get the specifications; analyze them and come up with feasible options.
HR has functional requirements and possibly some reporting requirements, but HR should not be designing the database. Designing that database is not - in my view - an HR function. Now it certainly depends on your organization and management and their approach to data/information management. We've seen enough spreadsheet databases and non-normalized table designs etc, etc. You offer some options that are feasible, doable and even some samples --but only after you get some analyzed and vetted specification.

Yeah. Come to think about it, Im sure they're not designing them. But something went very wrong somewhere.

Ill have to see what is really going on in the background.