How is the SUBSTR keyword used in sql ?
SUBSTR is used for string manipulation with column name, first position and string length used as arguments. E.g. SUBSTR (NAME, 1 3) refers to the first three characters in the column NAME.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Is there a way to get indexed better by the search engines? 11.11.08
Yes. Put these two statements in the part of your documents: Both may contain up to 1022 characters. If a keyword is used more than 7 times the keywor...What does the “abstract” keyword mean in front of a method? A class? 27.10.08
Abstract keyword declares either a method or a class. If a method has a abstract keyword in front of it, it is called abstract method.Abstract method has no...Is there a way to get indexed better by the search engines? 09.09.08
Yes. Put these two statements in the part of your documents: Both may contain up to 1022 characters. If a keyword is used more than 7 times the keywor...How do you retrieve the first 5 characters of FIRSTNAME column of EMP table ? 26.07.08
SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;...What keyword does an SQL SELECT statement use for a string search ? 02.04.08
The LIKE keyword allows for string searches. The % sign is used as a wildcard....What are storage qualifiers in C++ ? 30.04.07
They are.. const volatile mutable Const keyword indicates that memory once initialized, should not be altered by a program. volatile keyword indicates th...What are storage qualifiers in C++ ? 23.02.07
They are.. const volatile mutable Const keyword indicates that memory once initialized, should not be altered by a program. Volatile keyword indicates tha...What does the “abstract” keyword mean in front of a method? A class? 16.03.06
Abstract keyword declares either a method or a class. If a method has a abstract keyword in front of it,it is called abstract method.Abstract method hs no body....What is the use of Internal keyword? 14.03.06
Internal keyword is one of the access specifier available in .Net framework , that makes a type visible in a given assembly , for e.g : a single dll can conta...Can you declare an override method to be static if the original method is not static? 14.03.06
No. The signature of the virtual method must remain the same. (Note: Only the keyword virtual is changed to keyword override)...