deleting specific text from multiple fields

[Guest]

How do I remove a specific character (the asterisk) from all fields in a table?

 

[Guest]

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

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

 

[Guest]

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

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

How do I remove a specific character (the asterisk) from all fields in a table?