Results 1 to 5 of 5

Thread: Question of the Day : SubString Usage

  1. #1
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    Question of the Day : SubString Usage

    Hello All,

    Let’s see how many of you work with different databases and programming languages....

    List the usage of substring with sample code in various databases like Oracle, SQL Server. My SQL, DB2 and Programming languages like c, c++, vb. vb.net, C#, java, jsp and so on

    Thanks,
    Jim


  2. #2
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    Re: Question of the Day : SubString Usage

    The Substring command returns the portion of source defined by firstChar and numChars.


  3. #3
    Expert Member
    Join Date
    Nov 2006
    Answers
    518

    Re: Question of the Day : SubString Usage

    substr(main, start[, length]);

    While 'main' is a string argument,
    'start position' & 'length required' are numeric.

    It returns 'length' number of characters of 'main' starting from the character at position 'start'.

    'length' is optional. If omitted, the function returns the rest of the characters from the position 'start'.

    Last edited by sutnarcha; 12-12-2006 at 02:18 PM.

  4. #4
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    Re: Question of the Day : SubString Usage

    Quote Originally Posted by sutnarcha View Post
    substr(main, start[, length]);

    While 'main' is a string argument,
    'start position' & 'length required' are numeric.

    It returns 'length' number of characters of 'main' starting from the character at position 'start'.

    'length' is optional. If omitted, the function returns the rest of the characters from the position 'start'.
    Sutnarcha, Please update post with programming launguage... Thanks, Jim


  5. #5
    Expert Member
    Join Date
    Nov 2006
    Answers
    518

    Re: Question of the Day : SubString Usage

    Well, this is general syntax.
    But if I have to name the programming language, I would say C/C++.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact