No not really. Is there any issue with doing this?

Do I need to do this: ALTER DATABASE [YOUR_DATABASE] SET OFFLINE WITH ROLLBACK IMMEDIATE

🙁

Thanks Gianluca

So when the command prompt returns 128.134.2.100 - it is really 128.134.002.100 ??

Thanks this works

Wow! Well done!

Yes I found one entry missing a comma. I don't suppose you have a trick to handle this one?

OK I will see if there is any missing commas, it may take a while, there is a lot of data.

When I run the query, the results starts to populate...

Yes you are correct, there are some nulls. Any way to handle these?

OK now I get "Invalid length parameter passed to the LEFT or SUBSTRING function"

It says Incorrect syntax near '<'

I also noticed it says the LEFT function requires 2 agrument(s)

SystemsRE has IpAddress and SystemID

I am just trying to get the IP Address separated from the MAC address in the IpAddress field.

I tried the example below and get "Invalid length...

I am trying to get this to work without sample data and I get IP_ADDR is not recognized. I really appreciated everyone's patience on this.

SET NOCOUNT ON;

WITH SAMPLE_DATA(IP_ADDR) AS

(...

OK I tried the example below and I get 'Invalid object name 'dbo.DelimitedSplit8k''

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(IP_ADDR) AS

( SELECT * FROM (VALUES

('132.135.3.100, fe90::bu54:e9z5:61a9:5003')

,('132.235.219.113, fe80::28d9:l69a:5bbd:gr2f')

) AS...

Yes the string only has IP and MAC address.

The examples you provided do work with a string. I need to do this for each row of the field returned...

OK, you mean something like this?

DECLARE (at)TestStr AS VARCHAR(20)

select left(@TestStr,patindex('%,%',@TestStr) - 1);

Correct, the IP Address is always first and ends with a comma

Sorry, solved - small issue on my end