Remove everything between the pound signs

[Guest]

How do I remove everything between the pound signs in a query? I have no
control over the source table.

EMPLOYEE ID
abclark
adunsky
agaudet#http://pws1.uswc.uswest.com/cgi-bin/nelno/supv_groups/?command=edit&cuid=agaudet#
ahawkin#http://pws1.uswc.uswest.com/cgi-bin/nelno/supv_groups/?command=edit&cuid=ahawkin#
ahelmbr
ajoiner

 

[Rick B]

one post per question please.