how to filter pipe symbol

hi my problem is how to filter data using special
character like pipe symbol "|"

when i use a select statement like

select * from table where columname='hur|hg^*('

i am getting error
please guide me how to solve this problem
thanking you

____________________________________________________________
*NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
       Visit http://in.mobile.yahoo.com/smsmgr_signin.html