converting int to char and concatenating

Question

converting int to char and concatenating

new coder

Right there with Babe

Points: 791
More actions
December 19, 2008 at 3:04 pm

#199168

I have two columns that have integer values. I would like to concatenate them as text and add them to a new column.
here is the code, but it's not working:
select cast (Table.column1 as char(10)) + ' -- ' + cast (Table.column2 as char(10)) as newColumn
Please help.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Are you getting an error? If so, what error. If not, what is the result you are getting, and what are you actually looking for?

vick.ram79 SSCommitted Points: 1637 More actions · Answer 2

You need to alias your table in the from clause...

or you will get an error like

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "#voodo.column1" could not be bound.

How To Post[/url]

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

Lynn Pettis (12/19/2008)
Are you getting an error? If so, what error. If not, what is the result you are getting, and what are you actually looking for?

cast (Table.column1 AS char(10))

The OP's post pre-edit was missing the AS.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 4

Now, it's just missing the FROM clause.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

new coder Right there with Babe Points: 791 More actions · Answer 5

thanks for all the help. I don't know what i was doing wrong. It is just working now!

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 6

Can you post what you ended up with, please? Thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

new coder Right there with Babe Points: 791 More actions · Answer 7

select cast (Table.column1 as char(10)) + ' -- ' + cast (Table.column2 as char(10)) as newColumn

from Table

....

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 8

Comparing that to the original, it looks like all you were missing was the FROM clause.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

new coder Right there with Babe Points: 791 More actions · Answer 9

No, I was just leaving it out, because it didn't make any difference. Wouldn't it be pointless to write a query without a from clause?!

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 10

In most cases, yeah...

In that case, I dunno what the original problem was.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)