Re: Separating People


Well, you have discovered why you should always store names in separate
fields :-)

:-P Where were you when I started this database five years ago?! Now if I
make that chage it will affect a couple dozen queries and reports that would
all need to be changed!

You can read the previous posts on this topic, and you will find ways to
separate the names as you stated by pulling everything up to the space to
one field, and everything after the space to another field,

I was looking for this, but couldn't find a reference. I searched for
'Update' in here and only found four references. Oh well. I guess you had it
downloaded before the server got rid of it, or maybe the news server I use
clears them out more frequently. Thanks for finding it for me. It worked
perfectly!

but here's the problem. What happens to "Mary Alice Smith"? What about
"J. R. Ewing"? What about "John Smith Jr."? You will most likely end up
with exceptions.

I don't care about those folks, I will just delete them! (OK, maybe not <sly
grin>) Turns out there weren't many, so no problem.

The common suggestion is to go ahead and run your update query, but then
you will need a human to go back through and fix all the exceptions.

Hope that helps,

It did! Thanks again!


.

Relevant Pages

  • Re: some c# questions!! please send me the answer
    ... TryParse first to see if the string is a valid DateTime before doing ... In .NET 1.1 all you can do is Prase and catch any exceptions ... Boxing is creating a "reference" shell around a value object so that it ... each "int" and then adds those object wrappers to the ...
    (microsoft.public.dotnet.csharp.general)
  • Re: what would you like to see in a 2nd edition Nutshell?
    ... but as a quick reference it is tricky; ... I beg you to include a ONE-PAGE table of exceptions that shows the ... inheritance hierarchy via indentation (e.g. like Python Essential ... The detailed info will probably have to follow. ...
    (comp.lang.python)
  • RE: The OutputPath property is not set for this project - interest
    ... I ran into this one time before when installing Compact Framework SP1 (maybe ... attempted to compile it, ... When choosing to "Add Reference" for a project we would normally click on ... everything compiles again and the exceptions are gone. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: NullReferenceException Message Feature Request
    ... I havn't been able to reproduce it in a debug environment. ... Please tell me you have exceptions set to 'break' in the debugger.... ... it's usually absolutely obvious what the null reference should have ... >> Bryan Livingston ...
    (microsoft.public.dotnet.framework.clr)
  • Re: Views on Metronet anyone?
    ... >>They don't seem to have a news server though (or at least I couldn't find reference ... >>to it on the web site) so I'm going to have to factor into the monthly cost the use ... Prev by Date: ...
    (uk.telecom.broadband)