String Handling Functions - Part 3

Today we're covering one of my favorite functions, CHARINDEX. Need to know if (and where) a string is located in a string? CHARINDEX is the answer. We've got a handful of examples showing how to use it. Be sure to look for the related lesson on PATINDEX, good to know both of them.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Mark Allman on 10/13/2010

I enjoy these small bites of sql everyday.

Todd Burrell on 10/13/2010

Very good, and timely since I recently put charindex on my radar/list of things to learn how to use.

Omair on 10/13/2010

Thanks. I always wanted to know what this was! Never had the time but this quick video was awesome. Its a string manipulation function, pretty cool!!!

padmini on 10/13/2010

Good

James Lawrence on 10/13/2010

Concise and informative

SQLSharma on 10/13/2010

Always a pleasure to learn from Andy.Thanks.

kevin on 10/13/2010

pretty good, maybe could have shown adding substring to parse out the field or even break up the columns.

kavita on 10/13/2010

very helpful

Divya B S on 10/13/2010

Nice to know...did not know about it.

Charlie Bruno on 10/14/2010

Excellent series on string functions...very well presented.

WChaster on 10/14/2010

I have need to split on a space so many times and never used charindex, seems simpler that mid.

A Alagu Ganesh on 10/15/2010

Good

FD928096BE on 10/16/2010

great

Prathap on 10/17/2010

Good

James Lim on 10/21/2010

I'll have to see where I can use this in my queries.

Steve Harris on 10/22/2010

May also want to mention that there are other string functions out there like patindex and others.

Ravi Shankar on 10/29/2010

super

Kat on 11/5/2010

Great info on the Charindex and using to split

Tonci on 12/10/2010

just plain excellent!