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,433 reads

Blogs

SQL Server Security Hardening Guide Using the DoD STIG Checklist

By

Security on your SQL Server is important. That doesn’t need any explaining. But where...

EightKB 2026: Registration is Open!

By

It’s that time of year again! EightKB is back on August 20th at 13:00...

TRY_PARSE Limitations: #SQLNewBlogger

By

I got a notification from a question I’d posted at SQL Server Central: Getting...

Read the latest Blogs

Forums

Are You Working More Hours?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Working More Hours?

Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

A Limited Startup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Limited Startup

Visit the forum

Question of the Day

A Limited Startup

I add this parameter to SQL Server 2025 in the Configuration Manager:

-mDynamics
What does this do?

See possible answers