Update query help (1 Viewer)

[DT]

I inherited a database. I want to change all the text/criteria in one column from * to ISSUE. Why they used the * I'm not sure. The problem I'm running into is that because the text is a wildcard it changes all the info to ISSUE. Suggestions?

Thanks

 

[boblarson]

use the Character CHR(42):

Update TableNameHere Set FieldNameHere = "ISSUE"
WHERE FieldNameHere = Chr(42)

Be sure to test it on a copy first.

 

[DT]

perfect...thanks!