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.

4.5 (6)

You rated this post out of 5. Change rating

2006-02-06

20,374 reads

Blogs

T-SQL Tuesday #185–Being a Video Star

By

This month we have an interesting invite. Erik Darling is the host, and since...

Building Resilience: Leadership Insights from Sports

By

In the bustling world of sports, leadership appears as a beacon of hope and...

T-SQL Tuesday 185 - Produce a Video!

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Read the latest Blogs

Forums

Snapshot Replication: Pre-application script to check prerequisites

By sqlsauce

Is it possible to write a script that checks a subscriber's environment for prerequisites...

t-SQL help..

By tran008

I have the following...anyone can point me the right direction to rewrite this code?...

install sql express

By sqlfriend

I yesterday dowload a sqlexpress and intalled on one of a testing database for...

Visit the forum

Question of the Day

The User Login

When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?

See possible answers