SQL Tutorial - 43: REPEAT() & REPLACE() Functions

[@rapid1610]

wow so nice and simple explanation!

[@theindiancarscene7000]

How do you use Insert function to insert a word in a string without deleting any other character in a string? It works the same as Replace function, just that you are typing the character you want to replace instead of mentioning the number of characters that you want to replace.

[@evansbauer8346]

hi i have seen all your videos and they have helped me a lot .and i would like to know something .how do you insert this * for example maybe you want to display the asterisks(*) first then in the middle put numbers and at the end asterisks again.like this ******95555*****

[@sunandareddy5126]

sir i have table i.e TBL in that table i have one column i.e SUB so i want to replace all strings in SUB column with different names ----------------------- SUB_COLUMN --------------------- MICROPROCESSORS AND MICROCONTROLLERS VLSI DESIGN DIGITAL SIGNAL PROCESSING LAB so,i want below format ----------------------- SUB_COLUMN --------------------- MPMC VLSI DSPL if it is possible send me query please

[@sharmiladuppala1289]

Hi what happens when u say insert('sharmila is awesome',1,5,'sharmi') I actually didn't download your software. Why don't you make videos with all (or considerable) test cases and more functionality concentrated??? cuz the basic functionality can be fetched from anywhere. Thanks !!

[@satishvemuri9052]

+sharmila duppala 'sharmiila is awesome'