Removing white space from list of names

I work for a school district and we have a need of exporting data from our SQL 2005 database. Often a student’s first or last name may contain a space. Unfortunately, the software into which we are importing the data does not allow for white space. After a bit of research I found the REPLACE command.

For example SELECT REPLACE (@NewFirstName,‘ ‘,’’) But this variable only works for a single name. How do I tell SQL to find the space and replace it with no space for a whole list of student names?

Thank you in advance -
David

exactly the same way, except with a column like students.student_name, instead of a variable like @NewFirstName

also, you have to use single quotes (next to the enter key on most keyboards) rather than those wonky microsoft "smart quotes" (a misnomer if ever there was one)

Thank you, Rudy, for your reply. That makes sense. However, when I run this
SELECT replace (STU.FN, ' ', '')

(i did use single quotes)
SQL responds with
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "STU.FN" could not be bound.

Do you have any suggestions? thanks again -
David

i'd have to see the entire sql statement

that was it ! :-)

you mean this? --it seems you've omitted the FROM clause

whoops - my mistake, much better now :-) thank you again