Excel → T-SQL › SEARCH

Excel SEARCH to CHARINDEX

Most Harbour columns are CI. CHARINDEX then behaves like SEARCH.

CHARINDEX('ltd', company_name)

A CS collation makes CHARINDEX behave like FIND. Check the column.

Canonical translation

CHARINDEX('ltd', company_name)

Then write it on a ticket

Monday is free. A colleague asks, you type, we mark it.

Clock in free