April 2018 - TechwithRiya
You are here
Home > 2018 > April

SQL:String Functions

String Functions In last post we discuss about UPPER(), LOWER(), REVERSE(), FORMATE(), REPLACE() ,CHARINDEX() string functions. And today we discuss remaining string functions. In this entire post for examples we use below table. Table: persons p_id firstname lastname city 1 Amisha Patel Anand 2 Bina Patel Baroda 3 Tina Doyle v.v.nagar 4 Riya Patel Anand 5 Nikunj Patel NULL LEN(): The LEN() function return the length of input string in terms of number of characters excluding the trailing