Removing Spaces 1

[johnrg1]

Hi,

Is there a way to remove empty spaces held by the database? I am using an SQL statement:
SELECT LecturerTitle + ' ' + LecturerInitial + ', ' + LecturerSurname As LecturerName

to select a name out of a database. but the initial field is two characters long, do when it is extracted it becomes Mr D , Parkinson with a space after the initial before the comma.

How can i get rid of the space?

Cheers

 

[LFCfan]

Hi
you can use the RTRIM function

SELECT LecturerTitle + ' ' + RTRIM(LecturerInitial) + ', ' + LecturerSurname As LecturerName

HTH

 

[HardcoreTechnoHead]

You can use the REPLACE function to get rid of the additional spaces

Something like
SELECT LecturerTitle + ' ' + REPLACE(LecturerInitial,' ','') + ', ' + LecturerSurname As LecturerName

Andie Harper
"If you can keep your head when all around you have lost theirs, you probably haven't understood the seriousness of the situation"

 

[johnrg1]

Fantastic.

Thank you very much.

John