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 85

Downloads 23

CodeID
DB ID

ANmarAmdeen
586
Attachments
Revisions

v1.0

Saturday
February
3
2024