Substr Function Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Substr Function Problem

  1. #1
    Join Date
    Mar 2000
    Location
    Karachi , Pakistan
    Posts
    2

    Post

    Hi Every One,

    I am using Developer 2000 with SQL Server, when i am using SUBSTR function in Developer 2000 it accept, but in SQL SERVER this function not accept, the function is MID in SQL server or SUBSTRING like this, Is there any one who can help me in this mater, or is there any other function avail which can solve my problem.

    Regards
    Kamal.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello;

    I do not know much about SQL Server
    But you could write a wrapper-function! ( a userdefined Function with the same Signiture ( Parameters )as the oracle-function)

    Function Substr(,,,) -- SQL-Server Warpper-Function
    BEGIN
    MID(,,,);
    END

    Orca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width