Is It Posible Two Different Data Types Cancatenating a single Query?

Question

4.50/5 (2 votes)

See more:

I am Mohan, I have One Doubt for SQl Query.

Two Different Data types Are there For Example : Int and String

Okey

Now I Concatenating This Two Columns in a Query...

Please Help Me as Soon As Possible...

With Regards Mohan...

Posted 15-Apr-11 1:50am

Mohankumar.Engain

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Accepted Answer · 2011-04-15T01:53:00

Solution 1

You have to use Cast or Convert[^]

Select CONVERT(varchar, intColumn) + strColumn ... from tablename

Posted 15-Apr-11 1:53am

Prerak Patel

Updated 15-Apr-11 1:55am

v2

Comments

m@dhu 15-Apr-11 7:59am

your query gives error. ;P

Prerak Patel 15-Apr-11 8:04am

using MSSQL?!! no way!!
I have used it many times
:omg:

m@dhu 15-Apr-11 8:10am

Did you check the tag SQL-Server.

m@dhu 15-Apr-11 8:10am

And I was talking about '...'

Prerak Patel 15-Apr-11 22:43pm

and that is for the other parts OP may want to select. '...' is not the part of SQL.

Mohankumar.Engain 15-Apr-11 8:13am

Thank u so Much... Mr prerak Patel

by mohan....

Aman4.net · Accepted Answer · 2011-04-15T01:56:00

Solution 2

Dear Mohan,

you can cast or convert one column to anther's datatype while you are concatenating the columns. E.g.

--Here CustomerId is Int and CustomerAdd is Varchar
Select Cast(CustomerId As Varchar(10)) + CustomerAdd from tblCustomer

Regards!
Aman

Posted 15-Apr-11 1:56am

Aman4.net

Updated 15-Apr-11 1:57am

v2

Comments

Mohankumar.Engain 15-Apr-11 8:15am

thanks for u

by mohan bye bye....