no ...it still errors out in View..

no...

The Primary Field Shows...

this query:
ACCESSPANE.PRIMARYIP,
  CAST(ROUND( (cast(cast(dbo.ACCESSPANE.PRIMARYIP as binary(4)) as bigint) / 16777216 ), 0, 1) AS varchar(4)) + '.'...

Excel has Power Query

Yes i can see the DATA fine when i do it thru query window.....its when i import it into EXCEL Power Query I am getting <Binary data>   not the full...

This is what i have in View...
But the ID isnt Binary data...its a bunch of 0x004 blah blah....I need the 0x004 there for this Query..

SELECT TOP...

Here is the View Query...

SELECT TOP (100) PERCENT dbo.CLEAR.ID, dbo.CLEAR.DESCRP, dbo.CLEAR_AUX.OWNER, dbo.CLEAR_AUX.EMAIL
FROM  dbo.CLEAR INNER JOIN
     dbo.CLEAR_AUX ON dbo.CLEAR.ID = dbo.CLEAR_AUX.ID
WHERE (NOT (dbo.CLEAR.DESCRP LIKE N'%----%'))
ORDER BY...

I created the Query with view...How do i convert the ID in VIEW?

how is it done in SQL?

The Query Is from SQL, an im Running that Query thru EXCEL Power Query.  When i put that query into Excel Power Query it Returns 

<Binary data> as ID