kudithipudi
IS-IT--Management
Hello Guys,
Have a question about trimming data. I have a column in a table with IP addresses as such
IP_Address
192.168.2.51
192.168.4.53
192.168.2.50
192.168.2.49
I want to take this data, remove the fourth octect and inset the new string into another table. Is there a way to do this in SQL? I know the part of inserting the data into another table. But am not sure how to trim the data. Any help is appreciated. Thanks much.
- V.
Have a question about trimming data. I have a column in a table with IP addresses as such
IP_Address
192.168.2.51
192.168.4.53
192.168.2.50
192.168.2.49
I want to take this data, remove the fourth octect and inset the new string into another table. Is there a way to do this in SQL? I know the part of inserting the data into another table. But am not sure how to trim the data. Any help is appreciated. Thanks much.
- V.