LPAD keyword

oracle India
  • 14 years ago

    Dear Developers,

                               I'm having one oracle procedure, I want to change that procedure int sql . that means migrating,, On that procedure(ORACLE) there is one keyword "LPAD" is used for padding  the value. What is the equivalent function or key word in Sql. Is there any keyword is used in Sql or we wrote a seprate function??

    Thanks in Advance...

    Regards,

    Raju

  • 14 years ago

    Hi,

        In LPAD is a sql funtion only. So you can use the same LPAD funtion in you new sql query.

  • 14 years ago

    Hi alman,

                        Can u explain Clearly?,. LPAD is a Keyword in Oracle. I need the equivalent keyword or function in SQL.

    Thanks In Advance.

    Regards,

    Raju

  • 14 years ago

    Hi Raju
     In SQL Server LPAD and RPAD are not available upto 2000. But i don't know in later version.

    So we need to build Stored procedure for overcome this issue. LPAD code is available in the follwoing link. So u can try to create RPAD using LPAD logic.

    http://www.databasejournal.com/scripts/article.php/1498521

    the follwoing link may also useful for u

    http://www.developerdotstar.com/community/node/319/print


    Good Luck

    Regards
    Hari K


















Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Engineers are all basically high-functioning autistics who have no idea how normal people do stuff.” - Cory Doctorow