Search field with SQL help

[rocco]

Hello,
I am a new to sybase an I would like to get some advice with sybase SQL.

I would like to do a search on a particular field in a table. Searching for any error message that is or the word 'err'

This is what I have but is returning nothing...but I know that I have some lines with err in them.

select * from sysaudits_02
where extrainfo = '%/*err*/%'

Thankssss....

 

[Massy]

Try

select * from sysaudits_02
where extrainfo like "%err%"