SQL instr

Searching for a string inside a string in SQL.
You may say it is the instr in SQL.
Also from on old archive I am starting to dig out.

CodeFunctionName
What is this?

Public

Not Tested

Imported

Q.    What is the equivalent of the "INSTR" command in SQL Server? (v1.0 1999.07.23)
A.    CHARINDEX ('pattern', expression)
select CHARINDEX ('b', 'something about instr')

Views 125

Downloads 53

CodeID
DB ID

ANmarAmdeen
610
Attachments
Revisions

v1.0

Saturday
February
3
2024