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

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

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;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

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