Microsoft, SQL Server, 2000, SQL - SQL Server 2000

Welcome Guest

Search | Active Topics | Members | Log In | Forum Registration

Forums.ITDVDS.com » ITDVDS » SQL Server » SQL Server 2000 » Microsoft, SQL Server, 2000, SQL

Microsoft, SQL Server, 2000, SQL

Options

Previous Topic · Next Topic

Calanit

Posted: Wednesday, February 20, 2008 8:40:05 PM

Rank: Member
Groups: Member

Joined: 2/16/2008
Posts: 29
Points: 87
Location: Seattle, Washington

I have two fields: Table1.SSN, and Table1.Last4.
I need a query that inserts the last 4 of Table1.SSN into Table1.Last4. The value of Table1.SSN should not be affected. Thanks in advance.

Russell

Posted: Wednesday, February 20, 2008 8:40:41 PM

Rank: Member
Groups: Member

Joined: 2/16/2008
Posts: 21
Points: 63
Location: Salt Lake City, UT

update table1 set last4=right(ssn,4)

Users browsing this topic

Guest

Forums.ITDVDS.com » ITDVDS » SQL Server » SQL Server 2000 » Microsoft, SQL Server, 2000, SQL

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



HOME \| ONLINE TRAINING \| OFFLINE TRAINING \| FORUM REGISTRATION \| IPOD READY MARKETPLACE \| FORUM HOME \| COMING SOON