SQL - Delete Spaces

[dsmith1000]

Got a little problem. Got this query -

SELECT [offices].[officeName]
FROM offices
WHERE offices.officeName Not In (SELECT office FROM dailyFlash Where fDate = [todayDate]
ORDER BY [office];

Using this query to get all the offices that have not placed a daily flash report into the system. How do I take out the spaces in the office name in both the main query and the subquery and compare that data? (For some reason the space goes away when updating with some office names. Therefore the need to compare without the spaces.)

Thanks for any help,
dave

 

[mithrilhall]

You might be able to use a replace function.

dim strNewName
dim strOldName 'This should get the value you pull from the database.

strNewName = Replace(strOldName," ","&quot

Something along these lines should work.