MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology

DATABASE & SQL/PLSQL

Using String Functions
Previous Home Next

This function use to format data that will meet specific requirements. Mostly they are used with the char and varchar data types. It used for implicit convert data to char to varchar.

SELECT function_name (parameter)

function_name is the name of the string function. parameter are required parameters for the string function.

 

Function nameParametersExampleDescription
ASCII(character_expression)SELECT ASCII ('ADI')Return 65 the ASCII code of the leftmost character 'A'
CHAR(integer_expression)SELECT CHAR (65)Return A the character equivalent of the ASCII code value
CHARINDEX('pattern', expression)SELECT CHARINDEX ('O','HELLO') (65)Returns 5, the standing position of the specified pattern in the expression
SOUNDEX(character_expression) SELECT SOUNDEX ('ADITYA')Return the four character code to compare the string
DIFFERENCE(character_expression1, character_expression2)SELECT DIFFERENCE ('ADITYA','ADI')Difference function compare the SOUNDEX value of two string and return a value from 0 to 4. The value 4 is best match.
LEFT(character_expression, integer_expression)SELECT LEFT ('ADITYA','4')Return 'ADIT', which is the part of character string equal in size to the integer_expression character from the left
LEN (character_expression)SELECT LEN ('ADITYA')Return 6, the no of character in the (character_expression)
LOWER(character_expression)SELECT LOWER ('ADITYA')Return 'aditya', after the converting (character_expression) to the lower case
LTRIM (character_expression) SELECT LTRIM (' ADITYA')Return 'ADITYA' without leading spaces. It removes leading blanks from the character expression
PATINDEX("%pattern%, expression")SELECT PATINDEX ('%TY%','ADITYA')Return 4, the standing position of the first occurrence of the pattern in the specified expression, or zero if pattern is not found
REVERSE(character_expression)SELECT REVERSE ('ADITYA')Return 'AYTIDA' , the reverse of the (character_expression)
RIGHT(character_expression, integer_expression)SELECT RIGHT ('ADITYA',4)Return 'ITYA' , the part of the character string.
RTRIM(character_expression)SELECT LTRIM ('ADITYA ')Return 'ADITYA' without leading spaces. It removes leading blanks from the character expression
SPACE(integer_expression)SELECT 'ADITYA'+SPACE(2)+'TIWARI'Returns 'ADITYA TIWARI'. Two space are inserted between the first and second word
STR(float_expression, [length,[decimal]])SELECT STR (123.45,6,2) Return 4, the standing position of the first occurrence of the pattern in the specified expression, or zero if pattern is not
STUFF(character_expression1, start, length,character_expression2)SELECT STUFF ('Aditya',2,3,'s')Return 'Asya'. It delete length characters from character_expression1 from the start and then inserts character_expression2 into character_expression1 at the start position
SUBSTRING(expression, start, length)SELECT SUBSTRING ('Aditya',2,3)Returns 'dit', which is part of a character string. It returns length character from the start position of the expression
UPPER(character_expression)SELECT UPPER ('aditya')Return 'ADITYA', after the converting (character_expression) to the upper case
Previous Home Next