ORACLE/MSSQL casting question

[B. Cavour]

I just changed a column from int to varchar.

what I want to do is change those values to strings

I'm having a hard time trying to find the command to do this

Many thanks,

BC

[Nicholas Paldino [.NET/C# MVP]]

BC,

I believe what you want is:

cast(<expression> as varchar(<string length>))

I don't know if it will work in oracle, but it will work in SQL Server.
It's easy enough to test in oracle.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"B. Cavour" <ca*****@thirdhayz.net> wrote in message
news:%2*****************@TK2MSFTNGP10.phx.gbl...

I just changed a column from int to varchar.

what I want to do is change those values to strings

I'm having a hard time trying to find the command to do this

Many thanks,

BC

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

What this has to do with oracle AND ms sql?

In which RDBMS are you working with?

IIRC, in Oracle there is no INT as a type, but numeric , just check the
PLSQL for the correct cast expression, this link was the first for a google
search of oracle numeric nvarchar

http://msdn.microsoft.com/library/de...classtopic.asp

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"B. Cavour" <ca*****@thirdhayz.net> wrote in message
news:%2*****************@TK2MSFTNGP10.phx.gbl...

I just changed a column from int to varchar.

what I want to do is change those values to strings

I'm having a hard time trying to find the command to do this

Many thanks,

BC