Re: String Concatenation

Rebecca Smith wrote:
> In past versions of Access it was a simple matter to create a persons
> full name from the three strings 'FirstName' 'MiddleInit' and
> 'LastName' and include a period after the middle initial. Using a
> plus sign before the middle initial kept the period from showing up
> if the middle initial was blank. Seems Access 2003 doesn't recognize
> this simple trick.
>
> So the question is, how do create a full name in a query without
> having a period show up between FirstName and LastName if there is no
> middle name?

Something else is going on because there is no change to Access 2003
affecting how the + and & operators work with respect to Null propogation.
I just performed the following test in the immediate window of Access
2003...

?"test" & ("." & Null) & "TEST"
test.TEST

?"test" & ("." + Null) & "TEST"
testTEST

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Cheap, cost effective upgrades
    ... You don't hear 3c no matter what you think and no matter ... so tune an open cord say a C so each note is ... cord - it s now sour. ... plucking both at the same time, then tune one of the strings until the ...
    (alt.guitar.beginner)
  • Re: Beginner needs help with text files
    ... Everything I am reading pertains to finding directories or files not finding ... to actually perform the extract function? ... I just need to search within the zip to find the strings that ... I don't think that will matter though. ...
    (microsoft.public.vb.general.discussion)
  • Re: New
    ... >> in part on how it's taught. ... using pointers and null-terminated strings instead of the ... actually do matter) is one of the ... and a competent C++ programmer ...
    (comp.programming)
  • Re: Cheap, cost effective upgrades
    ... You don't hear 3c no matter what you think and no matter ... cord - it s now sour. ... Is your tuner capable? ... plucking both at the same time, then tune one of the strings until the ...
    (alt.guitar.beginner)
  • Re: String Concatenation
    ... Rebecca Smith wrote: ... name from the three strings 'FirstName' 'MiddleInit' and 'LastName' and include a period after the middle initial. ... Seems Access 2003 doesn't recognize this simple trick. ... how do create a full name in a query without having a period show up between FirstName and LastName if there is no middle name? ...
    (comp.databases.ms-access)