search from comma separated values in sql server code example

Example: search from comma separated values in sql server

WHERE tablename REGEXP "(^|,)@search(,|$)"