Re: Some sort of Trim function and how to get ALL CAPS changed..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Webb via AccessMonster.com (forum_at_AccessMonster.com)
Date: 03/23/05 

Date: Wed, 23 Mar 2005 07:01:23 GMT

With regards to keeping the state in uppercase - well, if the state is
ALWAYS listed, and is ALWAYS listed as 2 characters in length, then simply
take your existing string, shorten it by two characters then append the
last 2 characters of it to itself but using strConv("YOUR STRING",
vbUpperCase).

However, I would seriously suggest removing state altogether, and placing
it into a separate field. 

-- 
Message posted via http://www.accessmonster.com

Relevant Pages

  • Re: How to convert Infix notation to postfix notation
    ... If this is for an error message, why isn't it using stderr for its output? ... array of 15 characters, and you call this function with the limit 15 on ... Making sure that the only string I allocate and append to, ... because mulFactor in all versions must needs incorporate the functions ...
    (comp.lang.c)
  • Re: Prothon should not borrow Python strings!
    ... """It does not make sense to have a string without knowing what encoding ... same cul de sac as Python. ... Prothon_String_As_ASCII // raises error if there are high characters ... Python's split between byte strings and Unicode strings is ...
    (comp.lang.python)
  • Re: Letter to US Sen. Byron Dorgan re unpaid overtime
    ... put them in stupid places. ... Programming is difficult (as you must surely appreciate, ... > strings will be in the range 1...1000 characters. ... impose an artificially small limit on string length." ...
    (comp.programming)
  • Re: Byte Array to String
    ... retrieved text will mismatch the original characters. ... encoding the characters. ... Dim strFileData as String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: A note on personal corruption as a result of using C
    ... impossible to write effective string validation routines by definition ... (Note that a string literal may contain embedded null characters; ... without resorting to abusive language. ... In practice, programmers typically use "struct" ...
    (comp.programming)