<p>How do I find a stored procedure in a Sybase database given a text string that appears somewhere in the proc? I want to see if any other proc in the db has similar logic to the one I'm looking at, and I think I have a pretty unique search string (literal)</p>

<p>Edit:</p>

<p>I'm using Sybase version 11.2</p>

In SQL Anywhere and Sybase IQ:
```
```
select * from SYS.SYSPROCEDURE where proc_defn like '%whatever%'
```
```
I'm not that familiar with ASE, but according to the docs (available from sybooks.sybase.com), it's something like:
```
```
select * from syscomments where texttype = 0 and text like '%whatever%'
```
```