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

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....

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

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

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

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us