"Vanessa" wrote:

> everyone,
> Is there is a INSTR built-in function at triggers? I tried to compare if a
> variable contains "FED".  I tried
>
> If INSTR (@myvar, 'FED') > 0
>
> but it said 'instr' is not a recognize functions.  Please help!

"Hari Prasad" wrote:

> Hi,
>
> See CHARINDEX and PATINDEX in books online. INSTR is the similar function
> available in Oracle.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Vanessa" wrote:
>
> > everyone,
> > Is there is a INSTR built-in function at triggers? I tried to compare if a
> > variable contains "FED".  I tried
> >
> > If INSTR (@myvar, 'FED') > 0
> >
> > but it said 'instr' is not a recognize functions.  Please help!