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