deleting a space tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have got the next problem,

When i export the querydata with adresse to an other programm, a part of the
adres is not right, before i want to export the data i want to change the
data into the right data.

I want to change 2024 JW to 2024JW , so without the tab

does somebody knows how to doe this (not by hand !!)

greating gregor
 
You can remove space between words, by using the replace function

Select Replace(FieldName," ","") As NewFieldName From TableName

But it will remove all the spaces you have in that field, unless you have a
rule you need to follow when to remove the space and when not to
 
If the space is actually a tab, you'll need

Select Replace(FieldName,Chr(9),"") As NewFieldName From TableName
 
Back
Top