Lynn Pettis (3/26/2012)

---

Evil Kraig F (3/26/2012)

---

GilaMonster (3/23/2012)

---

SQLRNNR (3/23/2012)

---

GilaMonster (3/23/2012)

---

You say that like it should be obvious it's a bad idea. I...

You did say previously:

Thanks for your reply....However, I have to create a new column based on this calculation and use that in a report. Your code is correct but I...

For those interested further may I suggest reading:

http://sqlblog.com/blogs/kalen_delaney/archive/2007/11/21/cloning-in-sql-server-2005.aspx

GSquared (3/23/2012)

---

So, since Google is the...

@min-2 is simply functioning as a "place holder" or intermediate value. You could alter the previous code to

SET @min-2 = CAST(SUBSTRING(@H1,CHARINDEX(':',@H1)+1,DATALENGTH(@H1))AS INT)+CAST(SUBSTRING(@H2,CHARINDEX(':',@H2)+1,DATALENGTH(@H2))AS INT)

INSERT INTO NewColumn -- Inserted new...

Here is one way of doing what you want, but I must say it is not very efficient, but for the life of me I can not come up with...

Well you have stated your requirement, as strange as it seems, but what is your question ? What assistance are you seeking ?

Looking for a better method to store...

Hugo Kornelis

When I submit a question (and I have done so multiple times already - 22 times, to be exact), I go through great lengths to prevent any errors...

L' Eomot Inversé (3/20/2012)

---

Gazareth (3/20/2012)

---

sknox (3/20/2012)

---

Koen Verbeeck (3/20/2012)

---

According to CREATE VIEW (Transact-SQL):

When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and...

Not fully aware of your situation, but have you considered creating a view(s) on those table(s), a view that does NOT contain the credit card column. That way you...

Best quick and be no means complete explanation .. but think of a data base as say a book with an index. If you want to find something in...

Jack Corbett (3/16/2012)

---

Brandie Tarvin (3/16/2012)

---

Run in terror. I am back!

Book 2 of Latchkeys, The Ugly Little Bloke by Robert Greenberger is out. Links are below.

Preview the book at...

Nice question on basics ... thanks

bitbucket-25253 (3/14/2012)

---

Now this is going to be slow and NOT the best solution, as others have stated the lenght of the data is too long. This might work for...

Now this is going to be slow and NOT the best solution, as others have stated the lenght of the data is too long. This might work for you.

DECLARE...