Robert Davis

  • Interests: Poker, computers, reading/writing horror fiction

SQLServerCentral Article

Practical Uses of PatIndex

String manipulation is not one of the strong points of T-SQL, but there are some functions that can greatly assist you with searching and working with character values. New author Robert Davis brings us a look at PATINDEX, one of the search functions and also explains the differences between it and the often used CHARINDEX.

(6)

You rated this post out of 5. Change rating

2006-02-06

20,399 reads

Blogs

PASS Keynote Shots

By

Rodney Kidd took some great shots of the keynote and published an album here:...

Microsoft AI Red Teaming Course

By

here is the compiled video of the Red Teaming course Microsoft put together.

What’s New at AWS re:Invent 2025 – Day2 Highlights

By

Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...

Read the latest Blogs

Forums

Fabric Mirroring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fabric Mirroring

T-SQL in SQL Server 2025: The UNISTR Function

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

How Important Are Real Time Decisions?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important Are Real Time...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers