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.

 

[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/d...ystemdataoracleclientoracletypeclasstopic.asp