concatenate names - remove blanks

[Guest]

I'm running thisquery to concatenate last and first names into one field.
How can I get the blanks out after last name? Thanks for any ideas.

SELECT [pt_last] & ', ' & [pt_first]
FROM batches;

The results look like:

SMITH , EARL

 

[Saran]

Trim it.

SELECT Trim([pt_last]) & ', ' & [pt_first]
FROM batches;
Trims both leading and trailing spaces.

If you are interested trimming the leading spaces alone use LTRIM( ).
For trailing spaces alone use RTRIM( ).

Thanks,
Saran.

 

[Duane Hookom]

In most Access data, you would not have to remove the blanks since
Access/Jet doesn't store blanks on the right. If you are getting blanks, I
assume you data is from another database application. Try use the Trim()
function:

SELECT Trim([pt_last]) & ', ' & [pt_first] As PtFirstLast
FROM batches;

 

[Guest]

Thanks, that is just what I needed!

In most Access data, you would not have to remove the blanks since
Access/Jet doesn't store blanks on the right. If you are getting blanks, I
assume you data is from another database application. Try use the Trim()
function:

SELECT Trim([pt_last]) & ', ' & [pt_first] As PtFirstLast
FROM batches;

--
Duane Hookom
MS Access MVP

I'm running thisquery to concatenate last and first names into one field.
How can I get the blanks out after last name? Thanks for any ideas.

SELECT [pt_last] & ', ' & [pt_first]
FROM batches;

The results look like:

SMITH , EARL

 

[Guest]

Thanks, that works and is just what I needed!