Re: Update any Mcsmith to McSmith, etc . . .

UPDATE
[Your Table Name]
SET
[Name Field] = Left([Name Field],2) & UCase(Mid([Name Field],3,1))
& Mid([Name Field],4)
WHERE [Name Field] Like "mc*";

Replace [Your Table Name] and [Name Field] with the appropriate names.

Cheers,
Jason Lepack

On Apr 30, 1:12 pm, Peter <P...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi gang,

I have a client who wants us to update a Last Name field to proper case for
any last name beginning with Mc. They want the 3rd character uppercased in
all such names. So any Mca . . ., Mcb . . . ., Mcc . . ., becomes McA . . .,
McB . . ., McC . . ., etc. You get the picture.

We are well aware that some names can actually be Mca . . . with the third
character retained in lower case. But the client wants all third characters
in upper case.

Anyway, I am look for a code that I could use to simply update the Last Name
field by running an update query.

Any ideas?

Thanks

Peter
ps - I have done a search on this subject, but the answers do not give me a
simple update query method . . .


.

Relevant Pages

  • Re: Update any Mcsmith to McSmith, etc . . .
    ... character retained in lower case. ... But the client wants all third characters ... Mc is pretty safe - Mac is much riskier (there's a family named Machado here ...
    (microsoft.public.access.queries)
  • Re: How do I stop a Winsock from buffering characters?
    ... from the client code and have the server see it right away. ... I don't see the server reads that you're talking about as having dropped ... first character of the client send. ... public delegate int MessageFn(long MessageType, ...
    (microsoft.public.windowsce.embedded)
  • Re: How do I stop a Winsock from buffering characters?
    ... The client is just doing this to send: ... Stream s = client.GetStream; ... I just wan to send one character ... from the client code and have the server see it right away. ...
    (microsoft.public.windowsce.embedded)
  • Re: What Is Wrong With Newswatcher?
    ... a client should adhere to this. ... The character "#" is unsafe and should ... like a usenet post for example, do not typically encode characters. ...
    (comp.sys.mac.advocacy)
  • Re: How do I stop a Winsock from buffering characters?
    ... Windows CE side and receive ASCII on the server side. ... Unicode characters will be 0x00xy where xy makes up the ASCII character, ... I have two apps one is a Winsock Client as in the following: ... public delegate int MessageFn(long MessageType, ...
    (microsoft.public.windowsce.embedded)