如何寫SQL statement that select the string contains ' 單開(編號：7583)

如何寫SQL statement that select the string contains " ' " 單開引號?
e.g
select * from table where companyname = Asia Int'l
thanks!