quagmired (3/17/2016)

---

Jeff Moden (3/17/2016)

---

quagmired (3/17/2016)

---

My personal favorite is, given the same accuracy, which ever is the fastest and least resource intensive. That's usually not REGEX as called from SQL...

Steve Jones - SSC Editor (3/10/2016)

---

PATINDEX is powerful, without a doubt. I have more of a fondness for charindex, mostly because I can indicate a start position. However, as Luis...

IF OBJECT_ID('tempdb..#yourtable') IS NOT NULL DROP TABLE #yourtable;

CREATE TABLE #yourtable

(

c1 varchar(10) NOT NULL,

c2 varchar(10) NOT NULL,

c3 varchar(10) NOT NULL,

c4...

You'll need to add a CHECK Constraint. The code will look like:

ALTER TABLE <yourtable>

ADD CONSTRAINT ck_constraintname

CHECK (column <> '')

Try

WHERE Item LIKE '%S' OR Item LIKE '%B'

Tell us what you're trying to do and I but someone can come up with a solution which that requires less code and performs much better. All that CASTing and...

Good article Steve. I think you under sold the power of PATINDEX...

CHARINDEX can start at a certain position in the string while PATINDEX can take wildcards. In this simplistic case,...

There's advantages to mastering Microsoft and advantages to diversifying your skill set. The great thing is that data is hot so, as long as your skills are growing, your career...

mciesiensky (3/8/2016)

---

Sorry. Took me a minute to see the "t.n" in the code. Added that to my output and I think that will work.

Now to convert that to...

You can also create an indexed view.

Really great work Hugo.

bismsit.29 (3/3/2016)

---

Hi Alan,

Thank you very much for replying back so early.

Its sort of a business requirement that's why i want to reuse them also this value can hold till 99999...

This link should help get you started:

https://msdn.microsoft.com/en-us/library/ms188282.aspx

If you post some ddl and sample data we can demonstrate on that.

Yep. And if you have DQS setup it's already available...

Duplicate thread. Direct any esponses to http://www.sqlservercentral.com/Forums/Topic1766578-3412-1.aspx