convert

[trilokharry]

select IntValue+VarcharValue from tbl but it's not possible so how to convert IntValue in varchar in query only like select convert.tostring(IntValue)+VarcharValue from tbl what can I do despite of convert.toString because convert.Tostring wrong thanks

You get the best out of others when you give the best of yourself.

[joemonvarghese80 yahoo co in]

hi You can use Convert function for this. like select convert(varchar,Intvalue)+varcharvalue from table. Regards Joe

[Krish KP]

Use Convert or Cast functions

SELECT Convert(VarChar(10), IntValue) + VarcharValue .....

SELECT Cast(IntValue, VarChar(10)) + VarcharValue .....

in the example I've used 10 characters i.e. max 10 degit number

Regards KP

[Ashfield]

Try using SQL Books Online rather than putting .NET code into sql statements and expecting them to work.

Bob Ashfield Consultants Ltd

[Mike Dimmick]

Generally I return just the data from SQL Server and perform any formatting necessary in the 'client' code (i.e. the code that called into SQL Server).

DoEvents: Generating unexpected recursion since 1991

[Niraj_Silver]

Hi... Try This One Will Work Select Convert(varChar(20), Role) + LogInID From LogIn By Take Care.. :)