[walkerSGUSD]

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

[r937]

Originally Posted by walkerSGUSD

How do I tell SQL to find the space and replace it with no space for a whole list of student names?

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)

[walkerSGUSD]

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

[r937]

Originally Posted by walkerSGUSD

Do you have any suggestions?

i'd have to see the entire sql statement

[walkerSGUSD]

that was it ! :-)

[r937]

Originally Posted by walkerSGUSD

that was it ! :-)

you mean this? --

SELECT replace (STU.FN, ' ', '')

it seems you've omitted the FROM clause

[walkerSGUSD]

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