Help with joining a varchar to a smallint to form TCP/IP address 2

[vamoose]

declare @server varchar(255), @device smallint

set @device = 10
set @server = '192.168.0' + @device

Keep geting the error: syntax error converting the varchar value '192.16.0.' to a column of data type smallint.

I need to form this: 192.168.0.10 with the two different data types.

Thank you.

 

[SQLDenis]

declare @server varchar(255), @device smallint

set @device = 10
set @server = '192.168.0' + convert(varchar(3),@device)

select @server

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[AlexCuse]

try this:

set @device = 10
set @server = '198.168.0' + '.' + convert(varchar(5), @device)

select @server

hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SQLDenis]

forgot a dot (.)

declare @server varchar(255), @device smallint

set @device = 10
set @server = '192.168.0.' + convert(varchar(3),@device)

select @server

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[AlexCuse]

Are you sleeping on the job over there Denis?

Sheesh

In your defense, it wasn't included in the original post (where I copied from)

Ignorance of certain subjects is a great part of wisdom

 

[SQLDenis]

>>Are you sleeping on the job over there Denis?

I am actually creating my 2007 partitioned views

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[AlexCuse]

Them's just jokes. I know you wouldn't sleep when there is code to be written

Good Luck with the views!

Alex


Ignorance of certain subjects is a great part of wisdom

 

[vamoose]

That works great. Thanks to SQLDenis and AlexCuse for the valuable information. Sorry about the missing (.) Have a star.