Re: Select without blank spaces

Ryan

SELECT employeeid, REPLACE(lastname+','+firstname,SPACE(1),'') as name
FROM upr00100

RLF


"Ryan Mcbee" <RyanMcbee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2A995187-4FD1-4956-9CF1-6160765C4A4D@xxxxxxxxxxxxxxxx
I am writing a query in which I want to select a field and not have the
trailing blank spaces. Here is my query: select employid, lastname + ','
+
frstname as name from upr00100

The results look like this "West ,Paul" or "Mcbee
,Ryan"

How can I get results to look like "West,Paul" or "McBee,Ryan"?

Thanks,
Ryan


.

Relevant Pages

  • Re: Get Result 1 Stdev Away From Mean
    ... that query in another query applying condition ... Hidden within the Access crosstab query is the ... Terms with aggregate functions are required since the crosstab query is a special ... employeeid for shipcountry.The cells of the crosstab contain ...
    (microsoft.public.access.queries)
  • Variable not returning/passing value
    ... The main form is based on a query that limits the dates to the current pay ... main form’s header houses the Employee Name, EmployeeID, Department, Team, ... changes the values in the TimeIn and TimeOut fields. ... I have tried the following code in the AfterUpdate events: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Display the output from a query in a textbox
    ... CourseTraining Table when I have an EmployeeID and LicenceID from the LInk ... "John Spencer" wrote: ... Post the SQL of the query you want to use. ... Access MVP 2002-2005, 2007-2008 ...
    (microsoft.public.access.queries)
  • Re: how to find who has and who has not taken "food poision" training?
    ... You can now create a query based on the Course and CourseDone tables. ... Group By the EmployeeID field, ... > Tony 002 kitchen ... > Boby 005 boss ...
    (microsoft.public.access.queries)
  • Re: Setting form control value to a variable in VBA
    ... DailyHoursWorked field is not rounding as the code intends for it to. ... There are two sub forms on the main form. ... >> limited by a query that shows week 1 in the current pay period. ... The EmployeeID is the Primary Key in tblEmpInfo. ...
    (microsoft.public.access.formscoding)