i have no idea which forum to post this to, thought i would start here. i have exported log files from TMG firewall and brought them into sql2008r2. i have a view that shows me the logtime, ClientIP, and username fields. So far so good.
The problem is that the IP address field looks like this: 0A370D16 - which, if adjusted, would be 0a.37.0d.16 = 10.55.13.22. The field is a string - how can i manipulate the select statement to make it look like an ip address (select blahblah as
View Complete Post