hello, everyone:

we can concate two strings when changing column name, such
as: select firstname +' ' + lastname as name from user;

but how can I concate two intergers(treat them as strings)?
when I use +, I alway get the result of addition.

Thanks

haiwen

try convert.ToString(number1) + convert.ToString(number2).

if you want to convert the result to a number then wrap the above command
around a

convert.ToInt64 command.

hope this helps, let me know!



"haiwen" <(E-Mail Removed)> wrote in message
news:022301c34d6d$df36a420$(E-Mail Removed)...
> hello, everyone:
>
> we can concate two strings when changing column name, such
> as: select firstname +' ' + lastname as name from user;
>
> but how can I concate two intergers(treat them as strings)?
> when I use +, I alway get the result of addition.
>
> Thanks
>
> haiwen

You need to CONVERT/CAST the columns into string (VARCHAR)
first then add them.

Tu-Thach

>-----Original Message-----
>hello, everyone:
>
>we can concate two strings when changing column name,
such
>as: select firstname +' ' + lastname as name from user;
>
>but how can I concate two intergers(treat them as
strings)?
>when I use +, I alway get the result of addition.
>
>Thanks
>
>haiwen
>.
>

hi, thank you for your help.

I try it, but I get the exception:

Exception Details: System.Data.SqlClient.SqlException:
Line 1: Incorrect syntax near '.'.

it seems it doesn't reconize the convert.ToString(number1)
I use C#.

Is there other way to do it,

thanks again.

haiwen


>-----Original Message-----
>try convert.ToString(number1) + convert.ToString(number2).
>
>if you want to convert the result to a number then wrap
the above command
>around a
>
>convert.ToInt64 command.
>
>hope this helps, let me know!
>
>
>
>"haiwen" <(E-Mail Removed)> wrote in message
>news:022301c34d6d$df36a420$(E-Mail Removed)...
>> hello, everyone:
>>
>> we can concate two strings when changing column name,
such
>> as: select firstname +' ' + lastname as name from user;
>>
>> but how can I concate two intergers(treat them as
strings)?
>> when I use +, I alway get the result of addition.
>>
>> Thanks
>>
>> haiwen
>
>
>.
>

that goes in the SQL statement. It is processed by SQL, not .net

--
==========================================
= Tom Vande Stouwe MCSD.net, MCAD.net, MCP
= 45Wallstreet.com (www.45wallstreet.com)
= (803)-345-5001
==========================================
= If you are not making any mistakes
..= ..you are not trying hard enough.
==========================================
"haiwen" <(E-Mail Removed)> wrote in message
news:04c601c34d74$1f54ebb0$(E-Mail Removed)...
> hi, thank you for your help.
>
> I try it, but I get the exception:
>
> Exception Details: System.Data.SqlClient.SqlException:
> Line 1: Incorrect syntax near '.'.
>
> it seems it doesn't reconize the convert.ToString(number1)
> I use C#.
>
> Is there other way to do it,
>
> thanks again.
>
> haiwen
>
>
> >-----Original Message-----
> >try convert.ToString(number1) + convert.ToString(number2).
> >
> >if you want to convert the result to a number then wrap
> the above command
> >around a
> >
> >convert.ToInt64 command.
> >
> >hope this helps, let me know!
> >
> >
> >
> >"haiwen" <(E-Mail Removed)> wrote in message
> >news:022301c34d6d$df36a420$(E-Mail Removed)...
> >> hello, everyone:
> >>
> >> we can concate two strings when changing column name,
> such
> >> as: select firstname +' ' + lastname as name from user;
> >>
> >> but how can I concate two intergers(treat them as
> strings)?
> >> when I use +, I alway get the result of addition.
> >>
> >> Thanks
> >>
> >> haiwen
> >
> >
> >.
> >

Select cast(col1 as varchar) + cast(col2 as varchar) from table1

John
http://mallsocket.com

"haiwen" <(E-Mail Removed)> wrote in message
news:022301c34d6d$df36a420$(E-Mail Removed)...
> hello, everyone:
>
> we can concate two strings when changing column name, such
> as: select firstname +' ' + lastname as name from user;
>
> but how can I concate two intergers(treat them as strings)?
> when I use +, I alway get the result of addition.
>
> Thanks
>
> haiwen

hello,John,

It works well! thanks a lot!

Haiwen
>-----Original Message-----
>Select cast(col1 as varchar) + cast(col2 as varchar) from
table1
>
>John
>http://mallsocket.com
>
>"haiwen" <(E-Mail Removed)> wrote in message
>news:022301c34d6d$df36a420$(E-Mail Removed)...
>> hello, everyone:
>>
>> we can concate two strings when changing column name,
such
>> as: select firstname +' ' + lastname as name from user;
>>
>> but how can I concate two intergers(treat them as
strings)?
>> when I use +, I alway get the result of addition.
>>
>> Thanks
>>
>> haiwen
>
>
>.
>