Does anyone know how to remove a dash from a field?
for instance this is
tblApHistDetail.glacct
6169-90
6169-90
6169-90
6169-90
1412-00
6122-10
6122-10
5220-01
5220-01
I want it to be this way
616990
616990
616990
616990
141200
612210
612210
522001
522001
I thought an Update - SET would work, but I cant figure out the Syntax.. Brain Fart!! Anyone?
for instance this is
tblApHistDetail.glacct
6169-90
6169-90
6169-90
6169-90
1412-00
6122-10
6122-10
5220-01
5220-01
I want it to be this way
616990
616990
616990
616990
141200
612210
612210
522001
522001
I thought an Update - SET would work, but I cant figure out the Syntax.. Brain Fart!! Anyone?