query question

[tom taol]

i have a table with a field.
table name = tbl
field name = fld

fld
abc
bda
cdfd
aadr

after query
kbc
bdk
cdfd
kkdr

i want to change a letter "a" to "k".

*** Sent via Developersdex http://www.developersdex.com ***

[pietlinden@hotmail.com]

Re: query question

look up Replace in help It does just that..