Qry to remove "_"'s from field? 1

[newyorkny]

Hi friends,

I had a data feed altered on me so that every address now comes out in the format "_123 Main Street".

Could some kind soul be so good as to guide me on formulating a query to remove that "_" and leave just the "123 Main Street"?

Here is the query that gives me all addresses:

SELECT TransferJanA2005.Activity1
FROM TransferJanA2005;

Many thanks for any guidance on this chore!

NYNY

 

[PHV]

something like this ?
UPDATE TransferJanA2005
SET Activity1 = Mid(Activity1, 2)
WHERE Activity1 Like '_*'
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[newyorkny]

Thanks, PH. That worked perfectly!

What's a good book for getting to that level of ease with SQL?

Many thanks. NY

 

[PHV]

Search your local drives for files named JET*.CHM

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244