SQL Server Forums - Query Help

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Query Help

New Topic

Reply to Topic

Printer Friendly

Author

Topic

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 07/02/2012 : 16:58:32

how to get the desired results from the following ip

TableA

Ip
-------------------------------
5.46.200.1.462222.2.1.2.3.4.5.1
5.46.200.1.462222.2.1.2.3.4.5

Expected output:

Ip
-------------------------------
5.46.200.1.462222.2.1.2.3.4.5
5.46.200.1.462222.2.1.2.3.4

thanks for your help in advance

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 07/02/2012 : 17:05:32

What is your business requirement? Just chop off the last 2 characters?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 07/02/2012 : 17:21:27

Yes ..exclude the last 2 characters.

yosiasz
Flowing Fount of Yak Knowledge

USA
1608 Posts

Posted - 07/02/2012 : 17:24:37

declare @whyalwaysme table(id varchar(max))
insert @whyalwaysme
select '5.46.200.1.462222.2.1.2.3.4.5.1'
union
select '5.46.200.1.462222.2.1.2.3.4.5'

select left(id, len(id) -2) from @whyalwaysme

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 07/02/2012 : 17:31:14

Thanks a lot it works..

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.