471,627 Members | 1,570 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,627 software developers and data experts.

ORACLE/MSSQL casting question

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
Dec 27 '05 #1
2 1220
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

Dec 27 '05 #2
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

Dec 27 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Philip Mette | last post: by
133 posts views Thread by jonathan | last post: by
35 posts views Thread by English Teacher | last post: by
2 posts views Thread by Christian Brennsteiner | last post: by
2 posts views Thread by James Alexander Starritt | last post: by
28 posts views Thread by prunoki | last post: by
5 posts views Thread by NormaJean Sebastian via DBMonster.com | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.