One option is .... Look at Red Gates' SQL Packager.

I know I'm commenting late, but at least OleHank titled the post appropriately.

I do not envy your position. :w00t:

DECLARE @t VARCHAR(15)

SET @t = '111.222.333.444'

SELECT PARSENAME(@t,4),PARSENAME(@t,3),PARSENAME(@t,2)

That's where it said FLOAT.

GOT IT.

Changed the datatype from VARCHAR(7) to VARCHAR(8) and back again.

But still unsure how this could happen?

Place it between the code blocks. Look to the left in the "Post Reply" screen.

another explination is to start your code with an

open bracket+the word CODE+a close bracket

[.code.] ...

We need a bit more info to help you. 🙂

Read this article and re-post.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Without address a "Why" a direct answer to your question is ...

DECLARE @t TABLE (codeValue VARCHAR(256))

INSERT @t

SELECT '6,16,26,35' UNION ALL

SELECT...

Read up on COALESCE in BOL.

Or you could take advantage of the fact that an IP address just happens to have four parts just like a fully qualified SQL object name and use PARSENAME. 😀

SELECT...

😛

Not so far!

$#&&@%....! ... Jeff, you just had to bring that up didn't you!

Michael Earl (6/18/2008)

---

So you need to change the design AND upgrade your server...

Is this a one-time update, something you intend to do regularly in batch, or something you need to...

Matt,

Thanks for the suggestion, but I left out one VERY important point. This needs to work on 2000 as well. I probably should have posted in that forum :hehe:

Anywho, I'm...

Nice. I'll give it a whirl.

Any more takers out there?