Mine is not being saved. That is the problem. What can I look at to help solve this issue.

Thanks

Andrew

Thanks Norman

That is just what I thought. The app, which is very poorly written, uses BCP to pump some data out of a table. I found out that the SQL...

Thanks Jason

That did perfectly, just what I needed.

Have a good one

Andrew

That is very close. But what I needed was each octet of the IP address in a separate select.

IP Address = 10.5.215.12

like this:

select the second octet AS secondOctet, third octet...