Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains LIKE in context, with comparison tables and the common traps.
Terms in this definition
- Pattern
A reusable answer to a recurring problem that places building blocks in context, explaining when, how and why to apply them and what compromises are involved.
- Full-text search
Keyword retrieval in Azure AI Search that uses an inverted index with BM25 ranking. It excels at exact matches on names, identifiers and product codes but does not catch paraphrased wording.
Related terms
- AD DS tier model
Older administration model keeping credentials within their tier: Tier 0 for identity systems like DCs, Tier 1 for servers, Tier 2 for workstations. Superseded by the enterprise access model.
- Admin monitoring workspace
A preview workspace for Fabric admins that appears automatically when an admin first visits Admin monitoring under Workspaces. Its data is read-only and refreshed daily, powering reports like the Govern report in the OneLake catalog, and admins can give others access with the Viewer role.
- Affordance (prompting)
Prompting approach where the model is offered callable tools or functions, letting it pass tasks like calculations or lookups to code rather than guess the answer.
- Agent Builder
A Microsoft Copilot tool where people describe a declarative agent in plain language, or fill in a Configure tab, and ground it in sources like SharePoint or Copilot connectors. If the agent later needs actions or workflows, a copy moves into Copilot Studio.
- Agent identity blueprint
Template in Microsoft Entra Agent ID that holds credentials for one type of agent and obtains tokens for the agent identities created from it. Policies like Conditional Access set on it reach all those identities; Azure RBAC roles cannot be assigned to it.
- AIA
A certificate extension pointing to where a CA's parent certificates can be fetched. Microsoft Cloud PKI provides an AIA endpoint per issuing CA, and that endpoint, like the CRL, keeps responding even while the CA is paused.
- AIProjectClient
Starting object of the Microsoft Foundry SDK, constructed from the project endpoint plus a Microsoft Entra credential like DefaultAzureCredential. Because only Entra ID authentication is supported, no project key or SAS exists.
- Alert Triage Agent
A preview Security Copilot agent that sorts DLP alerts for you, weighing the risk each one carries and placing it in groups like Needs attention or Less urgent. Running it uses security compute units.