Home Forums SQL Server 2008 SQL Server Newbies String Function Help RE: String Function Help
BriPan
SSCrazy
Points: 2061
More actions
November 18, 2012 at 10:47 pm
#1560167
( problem in your query
select
LEFT(127.0.0.1,len(127.0.0.1)-charindex('.',reverse(([Ip]))))
from tablename