deleting specific text from multiple fields

  • Thread starter Thread starter Guest
  • Start date Start date
Back up your data first, then try using update query with replace function,
to replace * with ""

UPDATE TableName SET TableName.FieldName = Replace([FieldName],"*","")
 
Thanks!

It worked but with a minor adjustment. I kept getting a syntax error so I
removed the tablename after SET

"UPDATE [roster tryout 2] SET StudentID = Replace([StudentID],"*","");"

That removed just the asterisks.

JV


Ofer Cohen said:
Back up your data first, then try using update query with replace function,
to replace * with ""

UPDATE TableName SET TableName.FieldName = Replace([FieldName],"*","")

--
Good Luck
BS"D


johnny vino said:
How do I remove a specific character (the asterisk) from all fields in a table?
Click to expand...
Click to expand...
 
Back
Top