help in msaccess

hi all
i have customer field name as custfield and the data is stored as "NYS INCOME TAX,"
i want to remove those quotes in the front and the end and remove the ,
i need something like this NYS INCOME TAX
can someone tell me how to do this in sql query
romeiovasuAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
select custfield, replace(replace([custfield],chr(34),""),",","")  as Cleancustfield
from yourTable
0
 
Rey Obrero (Capricorn1)Commented:
if you want to permanently removed them, use an update query

update yourTable
set [custfield]=replace(replace([custfield],chr(34),""),",","")
where instr([custfield],chr(34)) >0
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.