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
Re: Question of the Day : SubString Usage
The Substring command returns the portion of source defined by firstChar and numChars.
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'.
Re: Question of the Day : SubString Usage
[QUOTE=sutnarcha;3869]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'.[/QUOTE]
Sutnarcha, Please update post with programming launguage... Thanks, Jim
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++.