Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: UpDate Query to abbreviate long name + city ame

    Here is What I have . . .

    Code:
    UPDATE TblCRMLSOfficeRoster SET TblCRMLSOfficeRoster.OfficeName = "BHHS"+" "+[city]
    WHERE (((TblCRMLSOfficeRoster.OfficeName) Like "*Berkshire Hathaway Home*"));
    I'm looking for the abbreviated name BHHS plus a space plus the city name as represented in the city field.

    I don't see it?

    Thanks . . . Rick

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    don't see what?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •