Convert on Oracle

All
How do I perform select convert(char(4), 'abcdefg') on
Oracle...?
ThanksAre you trying to get the first 4 characters of a string? If so, try looking
for functions like SUBSTRING or LEFT in PL/SQL
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:1f3301c3fc37$8fd4e1c0$a401280a@.phx.gbl...
All
How do I perform select convert(char(4), 'abcdefg') on
Oracle...?
Thanks|||Hi,
You can use the below query in Oracle,
select substr('sqlserver',1,4) from dual;
output
--
sqls
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OrumP5E$DHA.2180@.TK2MSFTNGP09.phx.gbl...
> Are you trying to get the first 4 characters of a string? If so, try
looking
> for functions like SUBSTRING or LEFT in PL/SQL
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:1f3301c3fc37$8fd4e1c0$a401280a@.phx.gbl...
> All
> How do I perform select convert(char(4), 'abcdefg') on
> Oracle...?
> Thanks
>